エンタープライズ向けに構築

Formula to change RYGG balls when Project Stage changes

01/19/18 ... Any help in this matter will be greatly appreciated. ... Thanking you in advance. ... 0 ... Share on FacebookShare on Twitter ... americansurveymanagement35236 ✭ ... 01/20/18 ... I wil...

If / and forumula

This may be as simple as a formatting issue. ... Looking at the following If/And example, can you try following bracket usage around your column name? =IF(AND([Value 1]39 > 75, [Value 2]39 > 75), "...

automatic notifications when dates are passed

01/19/18 ... Hi Jim, ... You'll want to create a Reminder that is based off of a date column and contact column. ... More information on this is available in our Help Center: https://help.smartshee...

SUMIFS with 2 criteria

SUMIFS with 2 criteria ... rjudenberg ✭ ... =SUMIFS([JAN'18 fcast]19:[JAN'18 fcast]160, PRODUCT19:PRODUCT160, "Core: MMS", POSITION19:POSITION160, "CURRENT - CORE") ... 0 · Share on FacebookShare o...

Formula Help - 2 columns and % Calculation

Hello, ... Thanks for the question. ... If I understand what you're looking to do correctly, this can be accomplished using a nested IF formula including the AND and OR functions. ... More on all o...

Nesting a SUMIF function

Nesting a SUMIF function ... rjudenberg ✭ ... =SUMIFS([Q1]1:[Q1]13, CatA1:CatA13, 1, Data1:Data13, FIND("Blue", @cell) > 0) ... 0 · Share on FacebookShare on Twitter ... jagrant35081 ✭ ... This is ...

Automatic Checkbox

You can add formulas to both columns to do the trick. ... In the Terminer column row 32, add "IF(Statut32="done", 1) ... Be warned however, if you have formulas in those columns, then they become u...

pallet configurations in smartsheet

01/15/18 ... Hello, ... Can you elaborate more on what you're wanting to accomplish? ... Happy to advise with more information.

Is there a formula that will work for this?

Is there a formula that will work for this? ... You might need to test this out a bit more extensively, but I was able to come up with a formula for resource allocation based on your sheet: ... =SU...

Sheet Column References in Equations

01/16/18 ... Hello, ... Thanks for the question. ... We don't currently have a way to convert a column reference to a number. ... I recommend using the "Submit Product Enhancement Request" link in ...

Links with Logic

Hello, ... Short answer: Not yet, but soon. ... Longer answer: Currently, there isn't a way to automatically link cells across sheets. ... Cell links must be manually created. ... Later this year (...

Formula to calculate the next Friday after today

What is supposed to be displayed when opened on Friday or Saturday? ... Last week or next week's Friday? ... The WEEKDAY function returns a 1 for Sunday, regardless of which day is the start of you...

Human Resources Time Off Requests with Functionality

Hello, ... We wrote a blog post on how you can use resource management to help you with vacation time: https://www.smartsheet.com/blog/support-tip-manage-vacation-schedules-resource-management ... ...

Allow multiple task dates within the same row have different colors

I would also like to have multiple date ranges within the same row. ... I would like to be able to look at a project (start to finish) but also like to see Section A, Section B, and Section C date ...

NEW! Timeline view

yes! Really looking forward to the dashboard part of this feature set! ... Seems like it has nice possibilities but to me, glitchy right now. ... For example, in one project when I group by assigne...