-
Track Cell Increases
How can I track when the numbers in a cell increase? We have cells that fluctuate all the time. They contain SUMIF formulas that pull from another sheet. I'd like to know when a cell increases- not just if it changes at all. Is this possible?
-
Indent from a form
Is there a way to have a row come in automatically at the same indent level as the row above it? My top row is a parent row with calculations based on all of its children. The children rows are all web form generated and they do not come in indented so I have to manually indent each row as it hits the sheet.
-
Status Colours
I see that there are 2 choices of 4 Status Colours: Green, Yellow, Red, Blue (or Gray). Could we get an option for 5 Status Colours? Blue - Not Started Green - In Progress Yellow - At Risk Red - Behind Schedule Gray - Completed Thanks,
-
Portal Publish View - editing
Hi Good afternoon We have a shop management portal that we were making revisions to the sheets directly in the portal home page now we cannot and this comes (attached). How do we change this so we can edit sheets right from the dashboard/portal?
-
How to set comment automatically sent to email?
Any one know if we can set auto email comments, instead of manually email comment? Thanks in advanced!
-
Locking columns until cells changed
Hi, Is there a way to lock columns until a cell in a different column changes? Basically I don't want personnel to be able to add text in the "Post AFC Change response" cell until the "LDO QA Check Complete" date is inserted. See attached image.
-
Applying Filter to Agenda
Hello all, I've been using Smartsheet for a few hours and i've been able to create in Gantt Mode without problem so far. The columns i've created allow me to filter tasks and help me read / correct / adjust the planning easily : Nice ! Now for the problem... The filters applied in Gantt Mode are effective in Agenda Mode…
-
Published User issue
The Activity Log properly logs the system users and their activities. What shows is the user's name and the activity info. I notice however, that several entries in the log lists "Publised User" as the person whose acivity is tracked. How do I tell who this "published user" is, and why isn't the user's nme listed instead?
-
How do I make required fields required on an Android phone?
I have created a time reporting collection form with required fields that works fine on my PC, laptop and tablet, but not on my Android phone. I don't have to complete any of the required fields on my phone app in order to submit the form. If I need to do something special in the setup for the phone app, please let me…
-
Calculate the cost after percentage discount if percentage discount is populated
Hello all, I have 3 columns in my Smartsheet List Price, Percentage Discount and Net Price. If the List Price and Percentage Discount are populated for a row, I'd the Smartsheet to determine the Net Price based off List Price and Percentage Discount. Some will not include a percentage, so I can't use =([List Price]1) -…
