-
Special IF Formula for Stars
I have two columns: * [Infrastructure Project] is a checkbox * [Product Priority] is stars (0 - 5) If [Infrastructure Project]@row is checked, I would like [Product Priority]@row to be 5 stars. If it's not checked, I would like manual entry for the stars. This would be simple if [Product Priority] were empty, but I already…
-
Linked Cells that are not read-only
We keep our master calendar/schedule in Smartsheet. Every year, we create a new copy of the sheet and insert dates for the new year, but the majority of the other content stays the same. Is there a way to do a cell linkage where the linked cell in the destination sheet IS editable? For example, for each row on the…
-
Complex Formula for RYG Automation
I automated the RYG circles according to several columns of a Smartsheet grid for project management purposes. The logic is below: IF [Proposed Product Launch Date] <TODAY, "Gray" IF [Proposed Product Launch Date] >=TODAY AND [Deviation from Proposed Launch Date] <100, "Green" IF [Proposed Product Launch Date]…
-
Reference a Report
I am using a form to track time spent on projects. Right now, they select the project from a dropdown list that I manually created and then they type in the task and the hours worked. Ideally, I would like for the Task Name to populate according to those available based on the Project selected. For example, if the user…
-
Limit rows in a sheet
Is there a way to limit the number of rows created by a form? I want to use a form for people to register for a training event, but am limiting the number of attendees to 50. Is there a way to automatically deactivate the form when 50 rows exist in the sheet?
-
Complex IF AND Formulas
I'm trying to automate the RYG circles according to several columns of a Smartsheet grid for project management purposes. The logic is below (I've also attached a visualization of the logic): IF [Proposed Product Launch Date] <TODAY, "Gray" IF [Proposed Product Launch Date] >=TODAY AND [Deviation from Proposed Launch Date]…
-
Formula for Summary of Total Tasks and Completed Tasks
There is a smartsheet template set in the solution center called New Employee Onboarding. In the sheet "30 Day Employee Onboarding Sheet" the tasks are organized by Week and By Day. The formulas for counting Completed: # of # are working for each day, but the Cells that have a Weekly Total are not summarizing for the week,…
-
Helper Column Parents and Tasks with 0 Children
I am using this formula in a helper column to identify which of my rows are "parents" however I would also like to Identify Rows that are Projects or also "Parents", but have 0 children " so that I can tag in conditional formatting along with my Parent Rows that have children. Can you help me create a formula that can do…
-
How do i get count of values against specific names
I have three columns . What i need is a formula to get details - If range responsible person is selected, what is the sum of target for each person seperately and in a similar way on the actual column what is the sum of actual by each person. The result i am look for should look like the one below. responsible person…
-
Creating a new Report based on a single Sheet
I create Reports frequently and am comfortable with the process. What I'm wondering is if there is an easy way to create a Report from within a Sheet that is based on that same Sheet? I guess I'm looking for an option in the File menu that says Create a Report from this Sheet vs. starting a new Report and then selecting…
