Is there a way to have the Risk Flag auto populate when the Health Check is Red

Answers

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Forumla Help: IF Statement with Vlookup Across Sheets
I have created two resourcing documents (pictures below for a visual) Resourcing Sheet - This is the sheet where we resource each project by person Resourcing Rollup- The sheet is rollup to show how many hours the are allocated each week by person and gives a rollup of hours What I am trying to do: Look up (example name)…
Sumifs with date column returning #Invalid Data Type
I'm attempting to use the sumifs formula and it is returning the error "#Invalid Data Type" =sumifs(Number:Number,[Date Column]:[Date Column],[Date Column]@row, Name:Name, Name@row) [Date Column] is a date column type; Number is a text/number with a formula that returns an integer; Name is a text/number with text inside…
Need IF statement to return a value based on sum between two numbers
This is my "if" statement - where am I going wrong? I am trying to code each line based on a value to help drive other actions =IF([Total Sum]@row >= $50,000.00, VP, IF(AND([Total Sum]@row <= $2,000.00, [Total Sum]@row > $500.00), A, IF(AND([Total Sum]@row <= $5,000.00, [Total Sum]@row > $2,000.01), SA, IF(AND([Total…