Hello! I'm trying to count the number of children whose "Final Approval Date" is between 6/1/17 and 10/1/17. I don't even know where to start with this formula. I know I've got my weekly totals like t…
I am working to create a Kanban Sheet and Cardview for continuous projects that we do in our office. We have the same subtasks associated with each client through 3 various phases. Is there a way that…
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. …