-
Read Only Mode
I'm facing a strange issue, i've created a mastersheet with around 5000rwos and 3500rows have data on it and those rows linked to another four sheets for particular data, now if i open my mastersheet it shows "we weren't able to load your sheet's cell links and had to make your sheet read only for now. sorry about the…
-
Need help merging repeated sub tasks with schedule steps
I am trying to figure out a way to merge high-level schedule steps with more granular tracker steps without having to build a whole new, super repetitive template. I have a master schedule that lists out all of the tasks for a project at the chapter level. However, each chapter breaks down into multiple parts, and those…
-
Error Check - Combining multiple IF/AND statements for calculation based status.
Hello, hope you are having a great day, I have issues using IF/AND combinations in formulae. I am trying to get a status off the percentage calculated in a different field (percentage value) and keep getting this error that says - #INCORRECT ARGUMENT SET This is my Formula- Details8 is the field where the percentage is…
-
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…
