-
IF And
Good Day, I need so assistance, I am trying to do the following I want to change my Project stoplight Status Column (RYGB ball) to yellow if the following condition is met if my "# of Days" column is > 138 and my "% Complete" column is < 50% Here is my If condition - =IF(AND(([# of Days]2 > 138, ([% Complete]2 < 50)),…
-
Send Row to another sheet (not via email)
I have multiple sheets with similar columns, and I'd like to be able to send rows between sheets easily. I know I can just cut and paste, but is it possible to make a button or other similar automation that moves the row from one sheet to another? The Send Row function looks close, but I can only find documentation on how…
-
Auto Flagging Yes or No answers
Hey everyone! This is my first post on smartsheet, so please bear with me. I'm trying to build a Production Report. I'd like the Red Flag to turn on whenever the "Was Production Met" column says "No". This is my current formula: =IF([Was Production Met?]1 = 0, 1). I can make it work with a checkbox, but no luck with yes or…
-
Time tracking for Collaborators
Hello If I set up time tracking in a sheet, can that be accessed/used by free collaborators? Thanks Megan
-
date formula referencing specific date cell
Hi, I am working in a date column that has the Effective Date: 05/13/2019. I want the Project Kick-off Date to reference the Effective Date - What formula do I enter so that: (i) the Year is always the year listed in the effective date cell, (ii) month is always January, and (iii) Day is always 01? I have tried this…
-
Notification Not Working
Hello! I am trying to setup an alert to notify me right away if the percent complete changes for specific rows in my Smartsheet. I set up an alert to notify me when "a row is updated" and selected the specific rows (Task Name) I need updates for. When I went to test it out by updating the % complete for one of the…
-
Cross sheet formula/reference
Hi everyone, This may be a basic answer, but I am trying to build a dashboard for my company. I have 6 reference sheets that I want to filter into 1 large sheet (the dashboard). The dashboard is an accumulation of weekly data that the 6 sheets feed into. Each sheet has a different employee inputting different data. So, If…
-
Symbols not changing based on the value in another cell
Hi. I have applied a formula where RYG "status" column is counting days to deadline and changes colors according to how many days are left till deadline (=IF(Done3 <> 3; IF(TODAY() - Due4 > -7; "Red"; IF(TODAY() - Due4 > -14; "Yellow"; IF(TODAY() - Due4 < 6; "Green")))) Now i want to add another formula to column(Drop…
-
Either / Or but not both
Hi Could someone help please? I'd like to set a formula in a sheet with say 3 columns. It needs to sum/count depending on the answer of the first two columns but not them both. If either of the columms say "Yes" then that is good enough to be counted in the 3rd column. For example: Column A: Yes Column B: Yes Total: 1…
-
Is there a way to send an attachment using Alerts & Actions?
I would like to have a Business Case sent automatically (as an attachment) when specific conditions are met after a web form is submitted. Is this possible? Thank you