I want to add a field that automatically works out the VAT in a seperate field so i can calculate how much VAT we pay on services. Is this possible? I have tried to add a formula e.g =SUM(amount)*20% …
I'm testing smartsheet to see if it can do better than the current excel spreadsheet that is becoming unwieldly with too many users. Basically I'm replicating the current structure I have in excel whi…
Why after i put the actual date on a task before the "planned date",it keeps sending me the reminder for this task although i already did it. Also ,why after pluging an"actual start date " it doesnt u…
I am looking to automatically populate a "STATUS" column with 1 of 5 values based on critera/conditions are outlined below. The key drivers here are the - [% Complete] - [Start] Date - [F/C Finish] Da…
I have used a google form for time worked and synced it with smartsheet. I then have a column on my sheet to work out how many hours have been worked on a particular day using the information supplied…
So I have a Parent row, Children row, and Grandchildren under the Children row/cell. On the Grandchildren row I want to take the Child cell divide it by the Parent cell and then multiply it by a cell …
Hi All, I am trying to do a simple formula, but can't seem to get it to work. I'm not an expert in either Excel or SS, so forgive me if this is terribly easy. I have two columns - one titled "Stock Qu…
Hi, I have ~30 products each with four price breaks and I need to determine the value for each order (a single product type is listed per row) based on the ordered quantity and its associated price br…
