I am struggling with another Countif formula. I have a working formula in one column that counts proposals filtered by month and year. I am trying to modify it to add another criteria so I can count p…
I'm using the Sum =SUM(CHILDREN()) to capture scoring of items by various teams, which is working great for each tool/category, but I want to now show a score by team (not just overall total by tool).…
I have a sheet with different values I would like to sum a group of them and not in detail. Example I have values like CAR, BUS, TABLE, CHAIR I am trying to use a countif formula to sum up a total off…
I want to concatenate two functions in a single cell and populate the values in the same cell separated by coma.In excel we do the same by =H65-K65 &","& I65-L65 but in smartsheet when I try the same …
I'm trying to convert an excel spreadsheet to a smartsheet. How would I convert this formula? =IF(SUM(AH6:AL6)=0,,AJ6+$AP6+$AS6+$AT6) Yeah, I am an extreme rookie when it comes to this stuff.
Not easy to relay what i'm trying to do here... I'm trying to establish a resource requirement list. We have 13 resources available for 4 categories. Right now, I have each category set to cap at 13 r…
I am trying to correct the SYNTAX for the below scenario as I repeatedly get #INCORRECT ARGUEMENT SET as a result on line 3. In the column labeled "Today" I have the following formulas: LINE 1 =IF(MON…
I was maintaining an excel spreadsheet with multiple tabs, and some of the fields under these tabs were similar, when i would update this field in master tab, then it would populate the same informato…
Hi again, Please need your help to correct my formula below. I wanted to count the number of projects that are due to start 14 days based on planned start dates but I am getting "Incorrect Argument Se…
For each of our sheets, we use a "Health Status" of Red, Yellow, Green to indicate how that task is going. I would like to create a report which looks across all sheets and simply counts up the total …
