-
Customizable Subject Line for Automated Alert
Good Morning Smartsheets Community! I have a stupid question that I am pretty sure I know the answer to, but just in case I wanted to reach out and check. Does anyone know, how customizable is the subject line of an automated alert? For example, below is a screen shot of the automated e-mail that gets sent out when a new…
-
Link an entire column from 1 sheet to another
I know you can do this at the cell level, but is it possible to link an entire column? I'm trying to save the time of linking over 6000 cells and want the ability to grow as I know the numbers will be increasing over time.
-
Formula to check box if Date is 7 days ago
Hello all, I have an idea to help me initiate an update request to add a new row. I'm thinking about adding a helper column with a checkbox and a column formula to check the box if the Date in the previous row is 7 days earlier than today. Do you think that will work and if so, can you help me with the formula? Mine is not…
-
Select Entire Coloumn in Sheet Summary Formula
This might seem super basic, but I am trying to build a formula in a sheet summary and want to define an entire column as the rane. I know that it should look like [Column Name]:[Column Name] but is there any way to select the whole column to automatically insert that synax into the formula without having to type it out?
-
TRying to collect all projects of a sales person
im trying to pull all the projects of a sales person like in a pivot but these fomulas only pulls at only 1 project. what is the suggested formula? Note: [Project Number Hidden]$20 = Sales Person =VLOOKUP([Project Number Hidden]$20, {Project Management Master SP to PN}, 3) =INDEX(COLLECT({Project Management Master…
-
Automated Alert to Someone Based on Parent Info only - not children
Hello - I need help creating an automated notification. I want someone to be notified when a project status = Complete. I created an automation that works, except I only want it to work in the PARENT rows, not any of the CHILDREN rows. I can't figure it out. Thank you!
-
If formula with nested AND, OR, NOT ISBLANK within
Not sure what I did wrong as when I'm reading through the formulat i wrote it seems correct, but I'm not getting the correct color value. Essentially I need: if the status is "Not Started" OR "In Process" OR blank AND the "End Date" is not blank OR is less than today's date, turn red. If the "End Date" is blank=Gray",…
-
Repeating # formula
this is what i have - but not working IF([row #]18, =1, "2", OR(IF([row #]18, =2, "3", OR(IF([row #]18, =3, "4", OR(IF([row #]18, =4, "5", OR(IF([row #]18, =5, "6", OR(IF([row #]18, =6, "7", OR(IF([row #]18, =7, "8", OR(IF([row #]18, =8, "9", OR(IF([row #]18, =9, "1", i want if the row above is a 1, the next row to equal 2…
-
Looking for most recent date
I have two sheets. The first is a tracker for up coming reoccurring tasks and the second is a copy of rows that have been completed. In the first sheet I would like to collect the date from the "date" column in the second sheet if the "Combined" column values match that on the first sheet and if "Most Recent" is checked in…
-
COUNTIF for Multiple Criteria
Hello, I'm trying to use the COUNTIF function to pull a total number from three different columns. Each total would need to include the criteria word for the three columns to be counted. The formula works until I add the third criteria and then it takes the total down to 0. I'm not getting an error, however. Can someone…