-
Assistance with IF, AND, OR statements
=IF([Due Date]@row > TODAY(), IF(AND(Status@row = "In Progress", Status@row = "New", Status@row = "Not Started"), "Yes", "No"))) The goal is to flag items for escalation based on the due date and status. If the due date is in the past and the status of the risk or decision is in progress, not started, or new then I need to…
-
Target Start/End Date
Ultimately, I need a good way to track if we are completing tasks on time based on our original estimates because we have users that estimate a task will take 5 days and when it takes 15 they just change the dates, and the project status still looks green, when is reality it is behind. I would like to have target start/end…
-
Plan Asset Manager - will it capture orphaned assets already in the system?
Hi, I missed the memo on the addition of the Plan Asset Manager role, and just assigned our admin account this role today. I did some digging because we had a person leave recently who didn't transfer assets before she left, and now we cannot access these sheets/reports. When we deleted her profile, we thought we…
-
Performing an Audit - Best Practice
Hi - we are performing an audit and we need to take the data, and have the consumer validate that its accurate, and if not, identify the change required. What's the best way to tackle that? I was thinking a form but there could be lines and lines of data to validate; is it as simple as having them review the sheet for…
-
Logo on Forms
My logo is tiny but can't be adjusted. Make Logo size adjustable on Forms.
-
Tracking Which Reviewers Have Not Submitted Forms Across Multiple Sheets
Hi Smartsheet Community, I’m looking for some help setting up a way to track reviewer submissions across three different sheets. Here’s the setup: We have three sheets (one for faculty, one for students, and one for scholarships). Each sheet lists applicants, and in each row we assign three Selection Committee (SC) members…
-
Add pages to Intake
How can I add pages to an intake form? I created an intake form that contains over 50 questions ad I would like to split them up into 5 pages of 10 questions but I'm unsure how to add pages within the Smartsheet form. Any help would be appreciated
-
Need a formula that returns a date while factoring in dependencies
I’m looking to add a couple of columns into my project plan sheets. SmartSheet already has a [Start] & a [Finish] column built into its project template, but I’m looking to differentiate between [Plan Start] & [Actual Start] and [Plan Finish] & [Actual Finish]. I renamed [Start] & [Finish] to [Plan Start] & [Plan Finish].…
-
Is there a way to "Group" by a column in a Sheet?
I am an Excel girl, so I am finding that some on the features I used often, are not available in Smartsheet. Now I use Smartsheet Gov. And I have a need to group by a column. We will be using the same sheet, and adding data from a new OY and Quarter. We would like to be able to collapse based on this primary column. The…
-
Question on Smartsheet Dynamic View Charges
Hi everyone, I’ve heard that Smartsheet might begin charging per Dynamic View. Does anyone know if this change will also apply to enterprise users? If so, is there any limit on the number of Dynamic Views we can create before the charges start? Thanks in advance for any clarification! — Mounika