Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
I can't figured out why #INVALID DATA TYPE auto fill when I haven't pick a date for the start and finish date. If I do have those fill out then the formula works fine but otherwise it just fill the duration cell with that error. I do have the duration column under Text/Number. The only thing that I can think about is that I have multiple reports that generate from this Master Sheet but other than that I don't see where is the mistake.
Try wrapping your formula with an IFERROR formula. Use "" to return a blank.
=IFERROR(NETDAYS([Concept Start Date]@row,[Concept Finish Date]@row),"")
Thanks!!!
It worked! I ended up using the formula
=IFERROR(NETDAYS([Concept Start Date]10, [Concept Finish Date]10), "")
it actually delete the #INVALID DATA TYPE
Using @row instead of the row number just makes it easier to copy formulas. You may run into a situation where you copy the formula, to say row 700, and the formula still shows row 10 (using the data on row 10, instead of row 700).
I have an end date column and want to add 30 days to that for a new column that shows due date. How do I add 30 days to a date automatically?
Why is it so convoluted now! I eventually figured out the changes and ended up with a sheet that Smartsheet completely reorganised the rows and the sheet is now useless to me as it is not in a logical order for me to easily restore to its original layout. This is not an "improvement"! It was far easier to upload data…
The dashboard previously contained 16 widgets, and I have confirmed that the widgets still exist in the backend. However, when I open the dashboard, nothing is displayed, and I am unable to enter Edit Mode or access the widgets/data sources. I have already confirmed the following: I am the owner of the dashboard and have…
