-
Release 2016-08-06 Duration
We can no longer use DURATION in a formula like MIN or MAX and I assume others. Even more oddly =MAX([Planned Duration]10, 4) throws an error. =MAX([Planned Duration]10) does not. just to be sure =MAX(0,4) does not either. I'm not a happy customer today. Craig
-
Release 2016-08-06 unintended consequences (part 2)
I noticed that many of my sheets were "updated" on Aug 7th. Many more than is possible or likely. But not all. So something triggered the update. Perhaps associated with the new formulas. Normally, I likely woudn't even notice this, but I'm in the middle of working with two clients that have far too many sheets and theyโฆ
-
Field Labels in Card View
Hi - I'm experimenting with Card View and am wondering if there is a way to include the field name as a label on the Card. I have multiple numeric fields that I'd like to display on the card - number of teams affected, # of hours estimated, site priority. I know their positions on the card but others will not. Let me knowโฆ
-
MATCH Formula
OK I'm loving these new formulas but I need help with the MATCH formula. I have column A with serial numbers in it. I want to scan serial numbers into column B and use the MATCH formula to match it to column A. How would you write the formula?
-
Auto-numbering not working anymore!
Hi, With the new update, the auto-numbering doesn't work anymore. I get the same numbers everytime with a new row. Please help!
-
Problems with formula AVGW
Hi The formula AVGW is not working anymore with the columnย duration. I mean when we write: AVGW(CHILDREN([% Planned]8), CHILDREN(Duration8))ย and duration is in days 1d, 2d, etc... the formula doesn't count the column duration as a number. This starts after the Smartsheet update!ย
-
#INVALID OPERATION
Guys, Something went wrong with the latest upgrade, I have too many spreadsheets to fix, this formula now give a #INVALID OPERATION error, this is one of my formulas:ย =IF(ISBLANK([Paid Date]5), [Due Date]5 - TODAY(), [Due Date]5 - [Paid Date]5) Please can this be resolved.
-
#invalid operation (new w/update)
In addition to the new features of Smartsheet brought about with the latest update, I'm also now getting #invalid operation error with this formula: =IF(AND([Start Date]285 - TODAY() = 0, [End Date]285 - TODAY() = 0), "Gray", IF(AND([Start Date]285 - TODAY() <= 45, [Start Date]285 - TODAY() <> 0), "Yellow", IF(AND([Startโฆ
-
Sights examples
I am just starting to look at using the Sights feature. I would like to hear what others in the community are doing for real life examples. Thanks for sharing!
-
Release 2016-08-06 Formula Argument Declaration confusion
The release notes says: Formula Argument Declaration Calculations can now run faster with the new logic for identifying a range. Rather than using =if(a1:a3) to specify a range in your formula, your functions will need to identify each cell, =if(a1, a2, a3), separately to be able to run the argument. Using the IF()โฆ