Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2015 Posts
Archives for December 2015
Discussion List
How do I create a formula that will subtract a percentage from another cell
If cell B2 in column titled "Total Cost" is $25,000.00, and I need to subtract 6.35%, what formula would help me do this?
How do you SUM a Child row with the condition that a separate colunm check box is ticked
Hi I want my spreadsheet to SUM the child numerical value under the condition that the tickbox in a separate column is ticked, so far I have come up with the formula ="Total Withdrawn: " + SUMIF(Completed:Completed , CHILDREN()) but it doesnt seem to work. Some help plese.
Update Requests
Can you set up an automatic update request to be sent to a person at the start, mid point, and finish date of an assigned task?
Change colours of block out dates on Gantt chart
Hi in the dependancies I have included the public holidays for our organisation. They are "blocked out" in a very light pink colour. Is there any way of changing the colour to make it look more obvious?
Subtracting time using formulas
Is there a way in Smartsheet, like in Excel, that you can subtract time? I have a "Completion Time" column, and a "Start Time" column, and I am wanting to get a duration of the time between. I want to evaluate the amount of time it takes to complete a task. AAny suggestions?
Cell linking between multiple sheets
I have 2 sheets I am working with that both have columns titled "Delivery Date". Sheet #1 is my "Initial Order" sheet, where I leave the "Delivery Date" blank. Sheet #2 is for my Production Manager. He also has a column titled "Delivry Date". When he enters what he expects the "Delivery Date" to be based on current…
Operators documentation
Where can I find documentation for which operators Smartsheet supports in formulas? Note: I am looking for documentation of operands ("+", "&", "<", etc.) not functions (SUM, INT, MAX, etc.). For example, here is the page that documents which operands are supported by Excel:…
Update Request single use link
Does anyone know if there is a way to allow a recipient of a "Send update request" to use the same link more htan once to update a particular row? An installation within my organization is a single day event but can span the entire day. I may need multiple check-ins from my field tech. Today, I send an update request to my…
Is there a way to archive completed tasks once "done" so you only see incomplete tasks in a daily To
I use one report sheet as My Daily Task Tracker and when I finish a project I select Done to show completition. However my list is full of completed projects now with lines through the content. I still would like to access this later but on a daily basis all I need to see is the Incomplete Tasks. I have set the sort to…
Are there ways to see other people's edits to a shared sheet in real time, rather than having to cli
Working on the same sheet together is more difficult when we have to click the refresh pop-up rather than seeing edits as they are made.