I am trying to set up a backup on our main sheet (This one has info from other sheets linking into it) I am able to select schedule recurring backup for my entire workspace, but we don't need all of t…
We are using a Smartsheet Report to upload data into a third party system. We are curious as to how often the Report will update. Example: If we open one of the Smartsheets that feed the Report and ma…
I am working on a restaurant buildout project list, and want to have a column for "Weeks till Opening Day" and another for "Days till Opening Day". Is there a way to have that automatically countdown …
Morning All, I have been trying to work out a formula for a calculation, i am not very good at formulas so i cant see where i have gone wrong, can any one help please? I need the below: If today > act…
Hi All, Still new to SmartSheet so help would be appreciated I am trying to sum a column if another column contains specific text "street lighting" I have come to =COUNTIF(Team:Team, "Street Lighting,…
Good Afternoon All, The Vice President has decided that for each project plan he wants to know the below information A count of the number of tasks that should be in progress (using start date) A coun…
I'm working with this formula, which gives me [Expected Completion Date]: =[Planned Start Date]1 + [Expected Days Duration]1 Without values in Planned Start or Expected Days, I get #INVALID OPERATION …
I am using a form to collect sign up information at an event. We will have multiple computer stations set up with the form. I wanted to ensure that we won't run into any issues with simultaneous usage…
I have several columns I use to track dates for different steps in a process. i.e. Ordered, Delivered, Installed. Is there a formula that will return the column name of the latest date across these co…
I hope someone can help me out here, or tell me how they approaches this :) In my department we have some issues when people are on a project and then going on vacation or out of office, it will show …