-
Formula to generate date 1 year from today?
I am trying to figure out a formula that will generate a date that is 1 year from today. For example, if we have a contract that requires 12 months of notice to cancel, and I have a column to track the Earliest Possible Termination Date, I want that column to tell me the date that is 1 year out, or 365 days after today.
-
Symbols for Multiple Columns or Adding Conditional Formating
Hi, Is there a way smartsheet can make it easier to apply conditional fomulas on multiple rows that meet the "N" = red and "Y" = green, rather than having only a format that can let me select multiple columns to the same color when 1 column has a "N" and setting a new rule each time I want to have "N" be red in a different…
-
Symbols on all Columns
Hi everyone, How can I apply symbols to all columns without have to individually right click on column to pick a symbol? Thank you!
-
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,
