-
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…
-
Testing a text value
How can a test be run on a text value to see if it matches?
-
exact match formula in Smartsheet
Hi, has anyone had any luck using an exact match formula is Smartsheet? I have two columns that have text in them. I want the 3rd column to tell me if column 1 and 2 are an exact match or not. I know how to do it in excel =Exact(A1:B1) but not sure how to set up in Smartsheet. Also, can you apply a formula to an entire…
-
Can Smartsheet import live stock or historical currency exchange rates?
For expenses sheets it would be very useful to lookup fx rates based on the expense date for calculating local currency to reference currency amounts easily. Thanks
-
Locking a Summary Row
Hello, Is it possible to have a summary row at the top of my sheet that is "locked" sort of. Meaning, when i filter on certain criteria, the summary row will only total that criteria.??
