Formulas
Discussion List
- I'm trying to work out a formula that says if the date in the [Date Column] is the current month insert the word current, but if it's in the previous month insert previous, if it isn't either of those…
- All I need is the correct return according to the Probability and Impact criteria in screenshot 1 into my Risk log in screenshot 2 Screenshot 1 =INDEX(COLLECT({Risk Management Matrix Range 1}, {Risk M…
- Hi there, I'm trying to write a formula wherein I can track elapsed time since an injury occurred at work. My team would submit daily on a form created and based on the logic I'd like it to parse the …
- Hello, I am trying to run a duration formula based on the start and end dates on a project and the estimated dates. The estimate dates are how long we think the project will take, the start and end ar…
- Hi all, I've got an INDEX/MATCH error that is stumping me. I have a lat/long identifier that I want to bring into a variety of other sheets. I am trying to match a street address to this identifier fo…
- I am trying to create a formula where I will get a count of total Solution Design by Zone. I can get the count for each separately but I can't get it to combine. Column 1 - Zone & Column 2 - "Solution…
- Hi Smartsheet Community, I'm looking for an "average" formula for a set of cells. However, some of the cells have a "zero" value and the formula musn't average across those cells, only ones which have…
- Hello Community, I am trying to find duplicate invoice numbers for the same client within two of my sheets. I need to show if there have been any duplicate invoices for clients using two criteria but …
- Hi there, I have a "Due Date" column and an "Order By Date" column. The Order By needs to reflect a date that is the Due Date minus our lead time (reflected in a third column and listed as a number of…
- I would like to return a value based on the total number of Medicare Days used prior to admission, plus the total days elapsed since admission to calculate day 100, or benefit exhaust date. I've worke…
