-
Percent Complete inconsistent in population
My sheet is very odd looking right now. I've assigned % Complete to the % Complete collumn. My results however are not all presenting uniformly. Some are rolling up as %, some as 0.xxxx and I can't figure the reason. I understand they represent the same thing, but formatting matters for some of my stake holders.. It's…
-
Can you add a VAT field in a smartsheet?
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% and also +=SUM(amount)*0.2 Neither of these work - it just shows an error message.
-
Calculating age in months
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 which tracks recommendations made, responses to those recommendations, and implementation dates. I need to track when…
-
Recurrent reminders
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 update the all other dates including the end date Thanks
-
How do I append a text description to a formula
I have an fx: =“Task - “ + COUNT(children()) How do I append 'text' to this formula?
-
Automatically populate a "STATUS" column with 1 of 5 values
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] Date - this is a column I have set up that uses a formula to predict a Forecast Finish ([F/C Finish] = (Today() + (R x D))…
-
formula help with symbols added
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 on the entry from the google form. For instance if Joe worked 09:00 to 17:00 and entered this on his google form submission…
-
Using a Child cell as a constant in the Grandchildren cell formula
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 on the grandchild row. I think I have a good formula - if I just can figure out what to call or how to indicate the Parent…
-
Need Help with Formula
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 Quantity" and the other "Reorder Point." I would like a formula to evaluate whether the stock quantity is less than or equal…
-
Order value based on price breaks
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 break. The really clunky method I have used so far is two main nested IF formulas and additional columns:- The first main…
