Formulas
Discussion List
- Hi everyone - I'm stuck trying to figure out how to format this question better. I'm working on building a dashboard for some reporting. The dashboard captures metrics from different quarters. (Averag…
- Very new user to Smartsheet. Two questions: What formula change needs made to not get error? Would it be better to do index and collect? Sheet: Fields Appointments: Appt #, Date, Time, MRN, LLL Langua…
- Hi all, I have a main sheet that gets updated every time we manually attach a new file to it. I have a number of reports and dashboards that automatically update upon this manual attachment. I would l…
- Hi, How do I use the =Sum(Children) function in Smartsheet to sum child rows and display the total at the bottom. I usually create a parent row, then add rows beneath it, indent them and add the formu…
- Hi! I am compiling a list of IP addresses that are associated with phyical sites. I am able to create a basic IF/Contains formula to populate the 'Location' column based on the 'IPv4' row. Issue: The …
- I am trying to use Index Collect for the following - and I am stuck :-) In the column "Validation NL" (upper table) I like to display the value of the column "Jira Status" if the value in the column "…
- Hello all, please let me know if this makes sense what I am trying to accomplish as I have been stuck on trying to get a fix for this. I am working to create a sheet that looks at an export out of a d…
- Hi All, While doing a global update I added new column ( type: Contact) I need to change the formula to that column. The issue is the formula is cross sheet =IF({Project Metadata (Do Not Edit) Range 3…
- Hi! I am basically looking for a formula that will return me a "T-2" result. For example, a product is launching on 12/31/2025, and XYZ activity is taking place 01/31/2025. Ideally, the formula would …
- Hello Friends! I have a form that my field crew uses to check the condition of our machines every morning, which includes the most recent hour/meter reading. There are (5) machines that we own that I …
