-
Adding a COUNTIF to a COUNTIFS formula?
I have a COUNTIFS formula... =COUNTIFS(Status:Status, CONTAINS("In Progress - On Track", @cell)). I have another formula that I need to add to the =COUNTIFS forumula... it's =COUNTIF(Level:Level, =0) . How would I combine the two?
-
Start and end date line chart
Hi Team, Can anyone help me how can I create a line chart based on below information. I
-
Adding months onto a date
Hi sorry I have seen this posted multiple times before but I can't get mine to work. I am trying to add the number of months in the "Monthly Review Frequency" to the "Previous Review Date" in the "Next Review Date" Column. I have tried this formula: =DATE(YEAR([Previous Review Date]@row), MONTH([Previous Review Date]@row)…
-
Cross-sheet referenced Date keeps defaulting to non-Date format
I have a column that uses 3 INDEX MATCH(es) to pull in a single date (there is no way this will ever pull in more than one date) using IF statements and "" if it is not found on a sheet. Formula works as planned, and I now have a System Column of "Created On" in my data (first pic). I can then change it to display as a…
-
Add IFERROR to formula
Hello, I have a tricky formula question. If I want to add a IFERROR to the following formula where would I go about inserting it? =(((IF(LEFT([End Time (HH:MM)]@row, FIND(":", [End Time (HH:MM)]@row) - 1) = "12", IF(OR(FIND("a", [End Time (HH:MM)]@row) > 0, FIND("p", [End Time (HH:MM)]@row) > 0), 0, 12), VALUE(LEFT([End…
-
Bring Task to a separated Smartsheet if due date
Hi, I have several tasks Smartsheet's to manage different projects. In order to avoid keep checking each Smartsheet for due dates, I would like to have a "Summary" Smartsheet that brings only tasks that are about to get due. How can I do this? Thank you
-
How to calculate No.of days without getting the value changed everytime a new row is added.
Error with the No.of days due column. If there is an automation set to send an email whenever the number hits 14, the value in this column keeps getting changed whenever a new row is added. Based on the formula, it changes to 14 first and then realizes it isn't 14 and changes back to 13. Due to this, repeated emails are…
-
merge cells.
Is there any way to merge cells in Smartsheet? this is critical to me and the JOIN formula is not the easiest way to address this like excel. Thanks, Eberto.
-
Calculating daily and last 30 days averages based on form submissions
Hello, I am collecting daily form submissions and want to have a dashboard to report on key metrics from these submissions. See screenshot. Here's what I want to calculate: Daily average for columns Role, Identity, Technique, Quality of Day, and My Score Today. At the end of the day I need to see what TODAY's average…
-
Column Formula Question
Is it possible to convert a cell formula to a column formula if it references a different sheet? Here is the formula in question: =VLOOKUP([Project Name]@row, {AM Master Info List Range 2}, 5, false) Where [Project Name] is a column in the current sheet, and {AM Master Info List Range 2} is a range from a different sheet.…