-
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…
-
Ensure a cell value is unique OR if already used, match the previously used value
I'm completely new to Smartsheet so I may be overcomplicating this, or going about it the wrong way. I want to ensure the value entered into a field is either unique within the column, or if it has been used before, then I want to to be exactly the same as a previously entered value. The use case is: I have a Smartsheet to…
-
Showing multiple true checkboxes as joined or concatenated text in another column
I have a volunteer submission form which has about 10 columns that exist as just checkboxes on/off - each of these relate to a conference work area and volunteers often select multiple. To easily view the data for a single person/row without tons of scrolling and looking up and down at column titles, I want to aggregate…
-
Financials: projected, actuals and variance
Hi! Very new to smartsheet and looking for any preset reports for tracking 3-4 year project financials, specifically projected spend, actuals, and variance. Does smartsheet have this type of reporting? Thanks!
-
Report with multiple tasks as ("what") conditions
How do I create a report with multiple tasks (in my primary column) as conditions? E.g. I wanted to display sheets in a report where Task 3 = Yes AND Task 5 = No.
-
Link comment
Bonjour à vous I would like to know if it is possible, to have a quick access of the good line in smarsheet when you link a colleague and you leave a comment with the @ and they open it in a email ? All the time when they open it, they are redirect in the master sheet... Merci