-
IF Formula Help
Hi guys, I would like to implement the following automation process of "% Complete" -> "Status". The approach would be: IF: % Complete: 0% -> "Not Started" IF: % Complete: 0% ≤x≤ 100% -> "In Progress" IF: % Complete: 100% -> "Completed" My current IF formula does not display and consider the last 2 conditions, I honestly…
-
Reference Formulas in Templates
Hello, I have created two templates from sheets that reference each other in a SUM+DATE formula. I would like the new sheets created by the template to reference each other, but at this moment they reference the old sheet from which the template came and need to be changed manually. Any way to achieve this? Thanks in…
-
Average/Roll Up Harvey Ball % Complete Symbol in Parent Row
Hello, I have a feeling this is going to be so simple, but I cannot seem to figure out how to average the values of the Harvey Ball % Complete symbol in a parent row. Per my screenshot, I want the Harvey Ball with the red arrow to average the values of the Harvey Balls beneath it. There is a parent/child relationship…
-
How to count children rows with multiple criteria
I have tried this many ways and can't figure it out. The column names I am working with are: "CaseRegNum", "Type of Review", and "Status". Each parent row is a different year and beneath each year are cases IDs (these are in the caseregnum column). The cases are categorized into "general" and "special" (this is the type of…
-
Cross-sheet reference limited to under 50,000 references
Excited about the increased cross-sheet reference limit to 100,000, I jumped on the bandwagon and started to replaced the Destination sheet LEFT(SUBSTITUTE(JOIN formulas with the Index/Match formulas using cross-sheet references. In this workflow, we are pulling data from 5 Source sheets into one “Central (destination)…
-
Rolling up Health to the Parent row
Is there a way to roll up health of tasks underneath the parent to reflect an "average" health, if you will? I have a formula for my children to render health, however, I can't seem to roll up to the parent. Would the same formula work the same in the parent row, if my formula is based on start/finish date and % complete?…
-
Is there a way to put a display name on a hyperlink in the Form Description?
I am trying to create a Display Name over a URL to make it more readable in the description of my form.
-
How to set up and automate a template for this report chart in the dashboard?
Hi guys, do you know how to set up the following report chart in my dashboard? I have seen this kind of report chart in one of the Smartsheet webinars. My requirements to this report chart would be : Every time I set up a new project plan, every person in my "Assigned to" column should be automatically involved in this…
-
Smartsheets not staying saved.
Hi, I have a smartsheets that has a formula in that works out the number of days between a date and todays date. Therefore every day the No. days goes up and I have a dashboard off of this. The issue is that when the formula changes the No. days I have to manually go into the sheet and click save for it to get to the…
-
Calculate cumulative duration of time spent in each status where status changes are bidirectional
Hi, I have a problem I am trying to solve in a sheet that contains hundreds of individual requests. Each request starts with Status = 'New' and finishes at Status = "Complete" in between there are 3 review statuses, "Review Department A", "Review Department B", "Review Department C" depending on the department the review…