-
Workback
Hello, I am relatively new to smartsheet and I can't seem to figure this out (I am sure it is easy, so sorry for the dumb question). I have end dates and durations secured and I would like the sheet to populate backwords based on the end date and I can't figure out how! Thank you for your help.
-
Conditional Formatting not working?
Hi, all. As the attached shows, I have a rule to turn the whole row a color if the Task Name contains "S18 D1". But, only one row is colored? Am I doing something wrong? Thanks!
-
Satisfy all requirements; with different formats of columns
Hello :) I need some help :) i think i have a few steps i will need to complete .. however big idea is to be able to make sure multiple columns have criteria matched; then send a notification with an attachment as well as mark a checkbox complete .. initially i think i need to use a countifs formula to tally all columns…
-
Conditional Fomating Question
Hi, I'm stuck on figuring out some conditional formatting. I have two date columns "Due On" and "Completed On" and would like to turn the Due On cell green if the Completed On date is before the Due On date. On the same coin, then I want to turn the Due On cell red if Completed On date is after the Due On date. I've…
-
modifying formulated cell in a report
In our main sheet, we have several simple Sum formulas for numbers and some for dates. We have several reports created that contain columns with the formulas. While in reports, you can change some data in each cell that will carry back to the main sheet and save. Other data is not allowed to change (even if the column is…
-
Formula creates a String - Cell no longer blank/empty conditional formating
Hello, I have a particular problem, I have a series of cells that have formulas to detect the checked values of a series of Check Boxes, creating conditional formatting and inserting 'N/A' in certain cells: =IF([Assemblage Mecanique]8 = 1, "N/A", IF(Coupe8 = 1, "N/A", "")) after this check the cell retains a sting of…
-
IF Function Due Date
I am attempting to create a project status column that is using the Harvey Balls (red, yellow, green and gray). I am wanting these to automatically change yellow when my due date column is 120 days with the due date, I would like it remain yellow until a date is entered in the completed column, then I would like it to…
-
Formula is changing after a date sort
Once my data is in the appropriate cells I want to perform a sort by Due Date. When I do this the formula =SUMIF($Equipment5:$Equipment171, "VUTEK", $Tue5:$Tue171) Changes to =SUMIF($Equipment16:$Equipment171, "VUTEK", $Tue16:$Tue171) Thus not including any data from rows 4 thru 15. I have locked the row with the formulas…
-
VLOOKUP Function
It seems like others have inquired about VLOOKUP. I'm sure this is in the works as part of "enhancement request". Is there a timeline when this will be released?
-
Items move to the bottom when marked complete
I'm helping my manager set up her "To Do" list and the way that she has been working is that she moves completed items to the bottom of the list, so that what she needs to do is always on top. Is there a way to set up Smart Sheets so that it automatically moves completed items to the end of the list? We know it can be done…
