-
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…
-
Request for generic color coding symbols
Please consider the addition of a "Generic" category of color symbols that we may attach to text/number columns for personalized categorization driven by formulas, etc. For colors, I would recommend a standard ROYGBIV plus black and gray. For symbol types, I would provide the above color scheme for circles, squares, stars…
-
Weeks to go Formula
Apologies if this exists somewhere - I tried to look but couldn't find exactly what I needed. Using smartsheet to project manage for an event - I am wanting to have a 'Weeks to Go' Column that counts down how many weeks until the exact event date along each task item. Thanks!
-
Feature Request
I have used Smartsheet for years and find it to be the best Project Management platform to date. I have a few features I'd like to suggest be added in the near future... please note if you'd find any of these helpful too. Hopefully this will help grab Smartsheet Developers/Engineers attention. - "View As (Other User)"…
-
Conditional Merge for Google Docs
Hey everyone, just trying to figure out if there's any way to use conditional statements with merge for Google Docs? I can see that someone has asked this question way back in 2015. I've tried to get around it by using conditional statements in my Smartsheets, however I've run into formatting issues. E.g. I want a…