Formulas
Discussion List
- Hello, I am new to Smartsheets and am creating a form to send out and collect orders from customers. Now the form works but I need it to populate the new rows that get added with pricing from another …
- I'm trying to write a function that will determine the county of an address based on the city. So far, I have created a table with several counties forming the vertical axis and then a list of all of …
- How can I select data that is older than 365 day? =COUNTIFS(Product:Product, "ABC", [Project Complete Date]:[Project Complete Date], "Where Project Complete Date is < 365 days from today"
- Hello – I am trying to create a formula that will change RYG automatically with the following criteria: Green: Any positive (%) Yellow: 0 to negative 10% Red: less than negative 10% With the below for…
- Has anyone used SS to track actual time spent? I am using the "Time Track for Client Projects" template modified for simple tracking of time spent for individual tasks by client or department. I cant …
- I need to populate the low range based on a match to a specific specialty and tier. The specialty is just a drop down but the Tier was based on the following IF formula: =IF([Points Total]11 <= 15, 3,…
- Hello, I was wondering is it possible to make the status RYG color changes when it is closer to the due date? For example: it shows red when it is due two days before the date and so on... Is there a …
- Hello, I have created 3 columns for the RYG, if the project is in the early stages the color green will show, if it is due within 4 days, yellow will show, and when it is due in 2 days red will show. …
- Is there a way to set a date to dynamically update to TODAY? For example, I have a sheet with start date finish date and duration. I want to track how many days into the project without having to upda…
- I have the following simple formula: =IF([Grasp of Material]3 = "Excellent", "100%", IF([Grasp of Material]3 = "Good", "80%", IF([Grasp of Material]3 = "Fair", "60%", IF([Grasp of Material]3 = "Poor",…
