Formulas
Discussion List
- Hi Everyone, I am creating a dashboard that will show which locations are open so the senior managers can quickly check in the morning. It is simple enough and will show on the Dashboard that the loca…
- I am trying to compile metrics and get them to auto-update to reflect the values of a drop down. For instance, if the drop down has options like "Physical Exam", "Digital Exam", "Advanced", I'm buildi…
- Hello everyone. I'm trying to use a WORKDAY formula to auto-update a list of due dates. We have several financial tasks that must be completed a specific workday every month. For example, the books ne…
- I am trying to combine all of the data into one cell for a row, but also any additional rows that share the same PO #. I then plan on taking this information and moving it to another sheet in order to…
- Hello, so this might be a strange one but doing this to run automation. i have the Bolo column set to check others sheets for serial numbers. i created a remove bolo column to search the Bolo Column a…
- Since Excel created XLOOKUP, I have lost my ability to properly do index/Match, I am getting an #INVALID COLUMN VALUE error. First here is my formula: =INDEX({Deliverable Tracker Approved Archive_Deli…
- Hi - I need help with a formula for a sheet summary field. 1. Open Tasks that are due in the next week. I want to capture a status that does not contain "Complete" and then if the task is within the n…
- I have the following cells that I need to use in an Index(match I cannot control the format, and ideally would like to resist using a helper column. The numbers vary in length and the blank spaces, "-…
- Hi, I'm trying to do something a bit complicated and hoping for some assistance. I am trying to join text from specific columns IF another column has specific verbiage in it (Campaign 1). Below is an …
- I LOVE that when you are writing a formula in Smartsheet, the formula adds colors to the references as you make successful references to cells. And how it goes "Grey" if there's a problem in the formu…
