-
Count of Issues by Month/Year
Hi All I want to add to my summary sheet a count of instances by month and I'm not sure what I'm doing (only 4 hours into using it!) My source sheet has the data formatted UK (dd/mm/yy) and I want to have the summary sheet show mm/yy with the count of instances that occurred within the respective month and year Anyโฆ
-
Count Criteria But Not Blanks
Hello! I am trying to count if a number is less than 45 but leave out the blanks. I have the first part of the formula working, just having trouble with the "do not count if blank" part. Can anyone help? =IF([Days to Complete Calc]@row < 45, 1) Thank you!
-
Help w/ Status Formula
Hello, I have the below status formula created but when I do not have a start/end date populated, the status is populating as "complete". I want it to be blank until all 4 dates are entered. Any suggestions? Formula: =IF([Baseline Start Date]@row <> "", IF(AND([Start Date]@row <= TODAY(), [End Date]@row > TODAY()), "Inโฆ
-
sumif function across multiple sheets
I am trying to build a roll up sheet that pulls criteria from multiple sheets, into one master document. I keep having an issue when I update the formula range from one sheet, it updates all the ranges when I don't want it to do that. Here is an example: For each FFE column, I have a formula specific to each Item groupโฆ
-
VLOOKUP example provided in documentation does not appear to be correct?
Smartsheet VLOOKUP example does not seem to be correct. In the example VLOOKUP Function | Smartsheet Learning Center, unless I'm missing something, the first formula example "IF([In Stock?]1 = 1 (true), VLOOKUP(โT-Shirtโ, [Clothing Item]1:Status3, 4))" defines the table starting "Clothing" column row 1 to "Status" row 3.โฆ
-
How to combine multiple IF statements into one?
Hello! I have 3 different IF statements in 3 separate columns that I would like combined into 1 if possible. The three IF statements/columns are the following: Red Status - if task is in the past and not checked complete: =IF(AND([End Date]@row < [Today Helper]@row, [Task Complete?]@row = 0), "Red", "Green")=IF(AND([Endโฆ
-
Workflow email content based on conditions/critieria
Hi All I'm very very new to SS (just got a license today) and I've been included in a team to improve the notification process to our wider audience with key information to help them complete actions quicker with minimum TLDR! Is it possible to take the column header and add the text to the output notification (email) if aโฆ
-
Counting # of tasks from a specific parent
Hi all, I am trying to count the number of tasks in my plan underneath a specific heading. However, I am unsure how to do this for 1 parent heading and not all of them. For example, I am looking to find the number of tasks under plan stage 2. Plan stage 1 Plan stage 2 Plan stage 3 I would use "=COUNT(CHILDREN([Taskโฆ
-
Rows could not be added to the destination sheet because it did not have enough cells remaining
Hi, Team, Could you please confirm why this workflow got this error while moving rows from source sheet to destination sheet as the destination sheet filled 4000 rows only yet. Error - Rows could not be added to the destination sheet because it did not have enough cells remaining.
-
How to Record Data Weekly
Hi, I now have 1 main sheet, and then 4 different sheets where it moves over data to, 4 times throughout the month, using automation to move certain rows by month on the I.e. 7th etc. then I have a dashboard showing the different data of the 4 sheets, so you see 4 times throughout the month how the numbers changed. Isโฆ