-
RYGB Formula
Can you help me create a formula for the following? If Assessment Sent is blank = Red If Assessment Sent is a date and Complete is blank = Yellow If Complete is a date = Green
-
Fill a column with a value based on the date of another column
I have a "Status" column where users can select "Completed" from a drop down list. There is another column called "Due Date" that already has value plus a third column called "Timeliness". What I would like is...when a user select Completed on the Status column, it will enter "Late" in the "Timeliness" column if the…
-
Remove all values from a multi-select column if they appear in a different column
I have two columns, one with a list of potential instruments and one with the instruments that aren't available. If I created a third column for instruments available, how would I remove the used instruments using a formula? All are multi-select columns
-
Get the latest value, based on a date, from a specific value.
I know that i will probably have to use Index, Max and Collect. I Just don't know how. This is the "Registry" table which is going to display the last value, based on the last date, based on the product SKU. Only with "In"s. And This is the "Movements table" which logs all the data. (This structure has the objective to…
-
Pulling next date from a sheet
Hello! I am looking for assistance with a formula that can pull in the next action date from one sheet to another. For context, we use sheets for customer renewal project plans. We also have a tracker that gives an overview of all the project plans and their name, completion, next action date, status, etc. What I would…
-
How to change color in Status Column when checkbox is checked.
I am looking to set my Status Column to Blue if the Done Column (checkbox column) is checked. I think I am having an issue with referencing the checkbox column properly. Would love any help. Thank you.
-
Auto copy from one column to another, but only IF...
I'm looking for a formula to copy information from one drop-down column to another automatically, but only if a third column contains a certain word. Is this possible? For example: Column 1 could say say "Title" or "something else" Columns 2 and 3 have a drop down menu of "In progress" and "complete" If Column 1 says…
-
The dreaded #invalid data type
Hi guys, I'm progressing with my basic formula however what do i need to add into the below formula as an example so i don't get the unsightly #invalid data type in a cell just because the start date is blank? =IF(MONTH([Start Date]@row) = 1, "January", IF(MONTH([Start Date]@row) = 2, "February", IF(MONTH([Start Date]@row)…
-
How to create a formula where if multiple criteria is met, a checkbox is marked?
Hello, I am pretty new to using smartsheet formulas, so bear with me! I am trying to create a formula where if multiple cells contain certain text, a checkbox in another cell will be checked off. I want the checkbox to only be marked if multiple criteria are exactly met. If all criteria is not met, I would like it to…
-
Using Index Match for Multiple Value Dropdowns
Hello, I'm trying to utilize index matching for some metadata sheets and using the formula I am currently utilizing, the data appears blank. The formula currently being used is: =IFERROR(INDEX({Portfolio Summary Data}, MATCH($[Project ID]@row, {Project ID}, 0), MATCH([Impact/Benefits]$1, {Portfolio Summary Header Row},…