-
Formula HELP
This discussion was created from comments split from: Need help with a date formula to always return a Friday date..
-
Project template sets - weighing options
Hello, all! What's the benefit in using the PMO template set over the Project Tracking & Rollup set or the Construction & Facilities/Multi Project set? In looking at each, and playing around with the PMO set, it seems like it might be more robust than what we need. We have multiple clients, some with multiple projects.…
-
Possible to Undo Sorting from a Day Ago?
Hello all, A colleague asked me for help with something in Smartsheet I could not solve so I wanted to ask for the community's thoughts! A collaborator sorted a sheet based on a particular column (in error) and were unable to undo it. This is the next day and I did not see any way to undo (additionally, there were no other…
-
Data Shuttle Offload Filter with Checkboxes
I am trying to use filters to only offload data where the Facilitator Helper Column box is checked, but the Finalize Archive checkbox is unchecked. I originally had the filters set up where the Facilitator Helper Column equals true AND the Finalize Archive Column equals false. I had 1 row that met that criteria, but all…
-
Nested If formula
I'm sure I'm missing something simple but I keep getting an unparsable for this formula and it shouldn't be. It should be a 4 =IF([Tickets % on Time]@row <=75%, 1, IF([Tickets % on Time]@row <=79.9%, 2, IF([Tickets % on Time]@row <=85%, 3, If([Tickets % on Time]@row <=92%,4, 5)))) The number in the Tickets% on Time row is…
-
ISO 8601
ISO 8601 ISO 8601 ISO 8601 ISO 8601
-
Index/Collect while meeting specific criteria and doing math
Good afternoon community, I'm in need of help with a formula that I feel has come close, but still just off of the mark. I have three sheets: The first is holding static data (Inventory Cost sheet). The second sheet (Tool Inventory) is where data comes into the sheet from a form and some math formulas do calculations based…
-
Sheets and Form and User want to View specific sheet
Hello, I need best practice on how to: Provide users to View only our tracking sheet. This tracking sheet tie to a Form (Request), which feed information to our request tracking sheet. I assume, the form-users and non-form users would need Read/View permission only for the tracking sheet. How to provide users specific…
-
Timeline View in Dashboard
Hello, I am trying to add a timeline view to a dashboard I am working on, not a gantt view. Is this feature that can be done in smartsheet?
-
Stop Predecessors from being deleted when a date is deleted
Sometimes we need to just delete the dates to start fresh or copy rows to use for another project, but deleting the dates also deletes the predecessors. I was trying to test a schedule template with many hours of work on defining the predecessors. When I wanted to blank out the dates again so it could be used as a blank…
