-
Harvey Ball formula based on dates
Hello, I have Revision Due column and I would like to automate the Harvey Ball formula that if the Revision Due date is older than today's date the ball would be Red. If the Revision Due date is within 60 days of today the ball would be yellow. If the Revision Due date is days the ball would be green. I've tried the…
-
Bypass Circular Reference
I've gotten myself into a bit of a pickle here and I see no way out, I have three columns: Primary, Level, and ParentID. The Level is the number of ancestors that a row has. The ParentID is an identifier of which Level 1 row this row is descended from. ParentID has a formula which is: IF(Level@row = 0, "", IF(Level@row =…
-
How to append sheets/consolidate multiple sheets in one sheet
Hi All, here are two different sheets populated from two different forms which are site specific The forms have information for people to read which are site specific hence why two forms Is there a way to append these two sheets into one like you can do on power bi using the append query function? please can you advise
-
If column does not contain string return N/A
Hi, I've created a formula to return me the average "word" that appears when the Title column contains the string "1. Establish Baseline for Web Performance": =IF(AND(COUNTIFS(Rating:Rating, "Extreme-4", Status:Status, "Open", Title:Title, "1. Establish Baseline for Web Performance") >= COUNTIFS(Rating:Rating, "High-3",…
-
Does Data Shuttle's Upload Data work in a sheet that has column formulas?
Hello! I've been having successful experience using Data Shuttle Upload Data with sheets that are referenced in another sheet. Now I have a sheet (sheet name: Tracking) with multiple column formulas, Data Shuttle Upload Data work doesn't seem to work... When I try to set up the workflow, the columns that are formula driven…
-
Formula Help Needed to Remove 0 From Results
Hello Smartsheet Community! I need some help to better understand what is happening. Why are only some of my results generating a leading 0 in front of my text? I have a multi-select column with a variety of text values for more than 20 groups. In the same sheet, but in different columns, I have written out a formula to…
-
Formula for checkbox column
Hello, I need a column formula that check marks all the children rows if the main parent row is checked. Thanks!
-
At risk flag formula help (please!)
Hi there, I am attempting to enter a formula in a flag column to automatically show at risk (red) when tasks are overdue and not 100% complete AND when due date is within 7 days and the %complete column is not 100%. Attached is a screenshot of what I have taken a stab at, I am not amazing at multiple condition formulas so…
-
IF formula issue (again)
I though this would be an easy one but it has me stumped again... So i now want a column to populate with a symbol based on an other columns status to give a pictorial representation of that status, is this possible? i.e. The symbol option used was from the 'Status' section and was the empty circle running through to the…
-
Formatting Charts
Hi all, I am trying to make a chart that references a report, and I have been successful in capturing the avg, and count values of groups I made inside the report. Where I am having trouble, is that I want to change the labels of the Legend. The legend pulls the name of the column it is referencing, however it is…