-
Need Help with IF and IFERROR
Hello, I have the IF part of the statement working just fine =IF([NEXT Month Quarterly from Today]@row = [NEXT Month Quarterly Due Number]@row, "Yes", "No") - basically it is evaluating if the next month from today is the same month as when the next maintenance is due. In rows where there is not yet data I am getting…
-
Formula help - difference between two form submissions based on a couple of
Hello, I need assistance with creating a formula to calculate the time difference between two submitted forms. One form is submitted when a person checks in, and a second form is submitted when they check out. I'm seeking a formula that considers the date stamps in relation to the Site Address and Check-in Action columns.…
-
Approval flow status - need help
Hello, I am in the process of creating a sheet (two separate forms depending on requesting line of business). My team handles one operation while my peer handles another. I have the automation when forms for specific lines of business it will send our respective teams an update will be sent via email. I also have a hidden…
-
IFERROR, NETWORKDAYS, and MATCH all in one?
Is it possible to have a formula that includes IFERROR, NETWORKDAYS, and MATCH? I'm working with two different sheets, both of which have a start date and an end date column, along with a project ID column. In a third sheet, I need to reference the start and end dates of both sheets using the NETWORKDAYS formula to…
-
Paste Formulas in Reports
We would like the ability to be able to paste formulas in reports and have the formula apply. Example: If I go into a report and paste "=Sum(Children))" then the cell returns this as a literal value of "=Sum(Children))" vs. my goal of having the Smartsheet calculate and display the value of SUM(CHILDREN))
-
Change Value in Symbol Column Based on Value of Other Column
Hello everyone! I have a Status column (Symbol type), where users can choose manually the desired status. I also have a Completed% column (Text/Number type), where a percentage is entered manually. I would like to change the value of the Status column to "Blue" when Completed% is "100%", but keep as is in all other…
-
Formula for past dates
Hi All, What's formula can I use to workout past dates, based on below example. Thanks in advance,
-
Formula missing 2 parenthesis
It showed 2 parenthesis were missing. I attempted to add them to the end, however I got an error that the syntax was incorrect. Screenshot of the error shown at the bottom. I am having issues with this formula. It is showing EVERYTHING as overdue (previous version). It is possible that the "Actual Implementation Complete…
-
Error calculating number of days between 2 dates
Hi all, I am having some issues running a seemingly simple formula to get the days between 2 dates in my sheet (screenshots below). I first tried to just subtract the two date columns and received an INVALID OPERATION error code (I did try and add + "" even though all three are date columns but nothing changed). =[Date on…
-
Formula to get sheet summary to update percentage complete based on category value
Hello! I am trying to manipulate a formula in my sheet summary to return a percentage complete based on the value selected in the dropdown menu I created. The formula I've tried (and a few variations of it) is: =100 * COUNTIFS([Review Complete]:[Review Complete], 1) / COUNTM([Primary Practice Area]:[Primary Practice Area],…
