-
Harvey Ball
You can see in this formula the Status (harvey ball) column defaults to Blue. It changes colors to Green, Yellow and Red with conditions from the Risk Rating Level column and it works perfect. However, I want the harvey ball to turn Red if the Risk Rating Level is Extreme even if the Complete checkbox is checked.…
-
Improve cell link formula
While doing the cell link formulas, one of the columns shows data even if the key identifier used is blank (Client ID), would you know why is it happening? but when the client ID column is filled, the column/row were able to update/pull the correct data. here's the formula I used: =INDEX({Client View Sales Region},…
-
Index/match cross sheet formula to account for misspelled data entry on source sheet
I'm attempting to figure out a solution for misspellings in the source sheet that I am referencing. I get #invalid value when the source sheet has misspellings. I do not control data entry on the source sheet and we have been unsuccessful with attempts to request misspellings be corrected so I am hoping there is a way for…
-
IF statement for multiple IDs
I have a column with multiple IDs and I want to select specific IDs and "complete" = 1 else 0. My current formula is : =IF(CONTAINS("000", [GAP Status ID]@row, 1, IF(CONTAINS("010", [GAP Status ID]@row, 1, IF(CONTAINS("020", [GAP Status ID]@row, 1, IF(CONTAINS("100", [GAP Status ID]@row, 1, IF(CONTAINS("110", [GAP Status…
-
Need help with whether to use Datamesh or Formula
I have a sheet that we would like to pull info from another sheet and I'm having difficulty figuring out the best way to do it. My target sheet has a bulletin that refers to several TOPP numbers. I would like to pull email addresses from source sheet for those TOPP numbers listed in target sheet. I can figure out how to do…
-
Alternative Formula to MAXIFS
Hi Smartsheet community! I am trying to find the maximum value in a range with both Vertical and Horizontal criteria. I was able to get the answer I need for a similar column using SUMIFS to add all the values together. Now I need to find the max value (however, Smartsheet doesn't have the MAXIFS formula). Could someone…
-
Copy a specific field in sheet 1 to a specific field in sheet 2
I have 2 SmartSheets - 1. My Project Plan and 2. My Communications Plan I would like to copy specific fields from one sheet to another. For example, on my Project Plan I have a "Start Date" on row 177 that I would like to copy to "Admin Date" on row 1 of my Communication Plan. The Project Plan dates change periodically and…
-
Linking Data between Sheets
I have 2 SmartSheets - 1. My Project Plan and 2. My Communications Plan I would like to copy specific fields from one sheet to another. For example, on my Project Plan I have a "Start Date" on row 177 that I would like to copy to "Admin Date" on row 1 of my Communication Plan. The Project Plan dates change periodically and…
-
I have a formula that tallies Net Work Days between "today" and a deadline.
I have a formula that tallies Net Work Days between "today" and a deadline =NETWORKDAYS(TODAY(), Deadline@row) However, if this deadline is in the past, I'm hoping that the formula will display an "N/A" as the result of the formula. Thoughts?
-
Mround and Round functions
Hi, What is the difference between the MROUND and ROUND functions? Also, I'm facing an issue with the rounding function in Smartsheet, where the result seems to be different from Excel. How can I ensure that the rounding function in Smartsheet gives the same result as in Excel?
