Formulas
Discussion List
- Hello! I'm sure someone has encountered this issue before so hopefully there's a work around it. We have a tracker with multiple service requests. We document each request in a very detailed way here.…
- Why are my metrics showing N/A on mostly all of my months for Long Term Project TCC? Please see formula below Populates only one month:
- Hi Smartsheets community, I am trying to create a summary field in a sheet that joins all the text from one column that meets these criteria: has a created date less than 20 days old has a label of "d…
- I've written out this formula numerous ways at this point and I think I'm just trying to work outside of my current abilities. I'm trying to write an "IF" formula to calculate the cost of shipping mat…
- I am not good with formulas and haven't been able to figure this one out with usual troubleshooting... I am using the following formula to return the next upcoming Review Date (screenshots of use belo…
- Hi friends, I need a smartsheet formula to check a star if any of the date columns are within the next 90 days AND if any of the text column values contain "text - value" in them. I have been using ge…
- I have a simple formula to calculate the number of days between a date and today. But getting an error. Any ideas?
- Asking this question again in case there are any more ideas - I have a sheet where a weekly status update is logged every week on a new row, including the Health "trend" (Up, Down, Sideways). I want t…
- I am trying to utilize a sheet for cost tracking. I have a column where the dollar amounts are being put in, how can I just have the value of the column to keep a running total?
- Hello, I want to make a column automatically populate a text word (i.e. CMHA) using Covert to Column Formula. I have done this in the past with a number but cannot remember and keep getting an error. …
