-
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.…
-
Counting Number of Installed Stores
Hello Smartsheeters, I am trying to count the number of installed stores using Smartsheet. I was able to use COUNTIF to get the number of chains that are installed by parsing the "Status" column: =COUNTIF(Status:Status, "Installed") However, I have another column that lists the number of installed stores/branches per chain…
-
Counting dates by week, months and year formula
Hi, I have a SmartSheet which logs enquiries. I need to create KPI report to measure the number on enquiries that are logged that day, this week, this month, last month, and year. Also a monthly running today for example Jan = 40, Feb = 50 and so on. Below is a screenshot of my Smartsheet and the column used for the date…
-
Formula no longer working
I have had a formula written for over a year and it just broke this morning saying it is now an #invalid operation. =City@row + ", " + State@row + " / " + [Location Number]@row + " - " + [Comp Short]@row