Checked and unchecked box
I need the amount from 1 column to appear in another column if the box between both columns are checked. Please write out the formula so I can copy and paste. Please see the attachment. Greatly appreciated.
Resource Allocation in Parent Rows
Does Smartsheet allow resource loading parent rows? I am trying to assign parent rows to staff and allocate percentage on the parent row, but it does not allow allocation entry on the parent row. I do have resources enabled on the sheet. I do not want the parent row to sum the allocation percentage of the child rows.…
Need a workaround so Parent Rows stay children rows when sorting
As I understand it, Smart sheet does not have the function to keep parent rows with children on reports like on the filter function. Which baffles me! Is there a work around that anyone can recommend for our situation? We currently have a Ready@Spike Date column. This will indicate when each child row will be completed.…
2 week task for 2 hours each day
Is it possible to have a task with a duration of say 2 weeks, but only allocate a fraction of the day’s hours to the assigned resource? For example, John Smith is assigned Qlik development that will last for 2 weeks, but will only be developing for 2 hours/day. I know it’s possible to change the default length of a day…
Did Smartsheet develop the software running on the "Community" or did you purchase collaborative software? If you purchased the software, can you tell what program is being used. I find the Community and how it functions to be very good.
Automating RYG balls based on Due date and completion status
Im having an issues creating this formula and was hoping someone could help improve on my formula. Im trying to create a HEALTH flag marked "Green" if the task is not due today, "Yellow" if the task is due today, and "Red" if the task is past due. However, the HEALTH flag should stay blank if: 1) the STATUS…
Smartsheet and the Elusive Roadmap
Dear Smartsheet users, A few months ago, we made the decision to remove our public roadmap, which has caused frustration for many of you, particularly in our Smartsheet Community. We removed the roadmap for a few reasons - as priorities and resources change, we couldn’t give the expectation that the roadmap was set in…
I am meeting with management and IT on Friday to persuade them to use appsheet with our Smartsheet data. I know appsheet is one of the approved integrations but is there any other documentation from Smartsheet that could help make the case for this?
How to manage Order with multiple items
I'm creating a form to collect Order information from users and facing a difficulty with an order having multiple items. I want to create a form which allows users to input multiple items in one order request. Each item will have each price and quantity. How can I do that in smartsheet? Thanks.
One stop shop for Project Managers
We use SharePoint for our project information, forms, and such and we use Smartsheet for our project schedules. I would like to be able to link the log in page in SharePoint so when my PM's click on the Smartsheet button in SharePoint that they are provided with the login screen to Smartsheet and get into their one or many…