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:
O.K. I have now inserted my formula to calculate a number of miles driven for a given trip. But now I want to copy the formula to the entire column. Right now the formula is just in row 1 of my SS and I know that I can grab the corner of row 1 and drag it down to copy the formula into the other rows but it puts a zero in those blank rows.
Hi Dennis,
To fill the formula down you can also use:
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
You can add an IF statement before your formula.
=IF(ISBLANK([Ending Miles]@row), "", PUT in the REST OF YOUR FORMULA without the equal sign)
I am assuming Ending Miles is the name of the column.
Hi everyone! I have a list of report dates that I want to be notified on, but am having trouble getting this set up. My thought process was to create a column with =TODAY() in the first cell, and then set up automations to be alerted when "Today" equals the "Report Date". My issue is that two are different formats. The…
Currently below is what Smartsheet allows for Group management. In our organization, this is very restrictive as it only allows 3 people to manage groups that required a lot of maintenance. Allows Group Admins this ability would make it much more flexible for large organizations who have multiple individuals with the…
Hi All i am trying to determine the stage that a project should have readhed by today, based on a series of milestone dates across the row however, in this particular example i am getting #invalid operation which may be due to the blanks. they are blanks because they currently have no date which is probably a flaw in the…
