-
Setting status based on Date Column
HI, I am trying to set a status based on the variable that the Date cell@Row is NOT blank. When I use this formula, I get "Invalid Column Value" =IFERROR(IF([Subscription End Date]@row > TODAY(), "Active", [Subscription Cancellation Date]@row <>, "Cancelled"), "") Anyone know what I am doing wrong? Thank you!
-
Automation of data in separate sheet
Hi, new to smartsheets, so I appreciate the assistance. I am trying to make it so when the Unique ID is entered on Sheet 2, Last name and First name autopopulates to sheet 2 from sheet 1. Sheet 1 would already be filled out. I have 2 smartsheets. Sheet one is below: Sheet 2 is below: Thank you.
-
Formula for dates with a date exception
I have the following date columns 1- last work date: 2- updated availability on: 3- availability expiration date: I want column 3 to have a date 60 days greater than column 1 unless column 2 has a date from the past 60 days. so far I have the first part but having trouble with the exception rule. Thanks for your help!
-
Calculating days between dates, 'unless'...
Hi folks, I have a date column for 'Suggested Risk Assessment Review', and a date column for 'Planned Review Date'. I need a formula to count the days between these (i.e. how overdue are they), UNLESS the 'done' checkbox is ticked. How do I calculate this? Thanks!
-
count if or count ifs formula
Good afternoon community; here is my formula question. I have a column using a dropdown menu (multiple selections) I want the column to count anything that says NEW and REMOVE. I cant seem to get the {}() "" , in the correct place =CountIF([Device Status]11:[Device Status]311, "New" [Device Status]11:[Device Status]311,…
-
Difference between Today & 7 Days Ago
We have a sheet that contains dates in the column headers with a # of widgets in the cells by office. We are wondering if there is a way to create a formula that would always compare the value for Today compared to the value from 7 days ago. I've attached what our sheet looks like to help understand what we're trying to…
-
Formula in cell in Text column not recognizing value in cell in Dropdown List Column in IF logic
Hi, I have a Dropdown list column with 5 choices. I want to use the value of the cell in that column in an IF function in another text column to add a value. The formula only works if I over type the value in the Dropdown list cell. It is not recognizing the value if it is selected from the Dropdown list. First row I…
-
Formula to pull values from another sheet based on another column
Hi everyone! I need some help pulling a value from Sheet A Column 2 to Sheet B Column 2 if Sheet B Column 1 is the same as Sheet A Column 1. In my example, I want the use cases to populate based on the use cases in the master sheet if the collateral ID is the same.
-
Multiple Formula/Cell question
Hello again, I have used the following formula and it gives me part of what I am looking for. Is it possible to add to it to subtract the value from another cell (also obtained by a formula)? =COUNTIFS({RBI CAPA Tracker Year}, Year@row, {RBI CAPA Tracker Dept}, [Primary Column]@row, {RBI CAPA Tracker On Time}, [Column6]$1)…
-
Trigger "Yes, No, Hold" on item returned.
Hello, I'm still learning SS formulas, and could use some help on what is probably a very "Smartsheet 101" situation. I have a "Item Returned" column that contains a date the item was returned, I would like the yes or no flag to come up on the next column to visually signal if it was returned. I figure a formula like…
