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.
Discussion List
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?
Resources without an e-mail address
I have a number of tasks that I need to assign and track resources to that do not have e-mail addresses. I was told to create a fake e-mail for these users so that Smartsheet could show allocations. When I first did this the program worked fine, and now 2 weeks later, it decided to not show these users in my resource…
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 I create a formula to SUM the Child column only if a tickbox in a separate column is ticked
Hi I need help with creating a formula to calculate the numerical values in the child coulmn but only if a tickbox is ticked. So far i have come up with ="Total Withdrawn: £" + SUMIF(CHILDREN(Completed2:Completed4)) Any help would be appreciated. Jordan
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.
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…
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?
Ressource Management
Within a team of 13 users in Smartsheet, we are struggling with the resource management and allocation of tasks. If I want to allocate a task to a staff member which will require 30% of his or her time over a period of 2 months (but without knowing when he or she will work on this precisely), how can I do that ? Also, if I…
Some general questions about alerts and reminders
I have some general questions about alerts and reminders that I could not find the answers to when searching through the help files and the community. Anyone know the answers? What time of the day does the alert or reminder get sent? I ask because I am trying to trigger reminder emails to contact list cells when a new row…
Importing Outlook Contacts
I am tryiing to import contacts from Outlook via a .csv file but only 5 of the contacts are importing. Any suggestions? Thanks, Bob
