-
Report - Finish Dates
I have a report I use which gives me all tasks in my projects that are overdue, due today, or due tomorrow. (A screenshot of the report builder is attached, below.) It stopped working properly yesterday, when I updated some dates but the task did not drop from the report. Today, it's showing tasks that are due a week from…
-
Report Sorting by Sheets Names Starting with Numbers Out of Order
Hello, I have a report being built off of 10 different sheets. Each sheet name is prefixed with a number and followed by the name (1. Project Name, 2. Project Name, etc). All was working well and the sheets were being sorted in the report by sheet name as expected until I came to sheet #10. Now the report sort order is 1,…
-
Scheduled Backup
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 that. All we need is one sheet to be backed up each week. When I right click on the sheet it will allow me to request a…
-
How often does a report update?
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 make a change and we do not open the Report, then when the third party system pulls data from that Report, will it have the…
-
Automatic Countdown
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 to a targeted date?
-
IF AND Formulas - Where am I going wrong
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 > actual start date & today is > actual end date & % complete < 100% = Red If today > actual start date & today is < actual end…
-
Sumif / Countif
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," ([Past Due Date]:[Past Due Date]) but it comes back with Unparseable and I am lost, It's probably something simple that i…
-
Tasks on Track and Off Track Count
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 count of the number of tasks that should have started and havn't (using % complete and Start date) A count of the number of…
-
Need a How-To: IF [blank addends], blank, IF [values], sum
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 in the Expected Completion. What's the simplest IF/THEN to use that will return a blank in EXPECTED COMPLETION if we haven't…
-
Simultaneous use of form by multiple users
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 / submittal of the form by multiple users. Thanks!
