Hi all, Just to be upfront, formulas are my Achilles heel, so I'm not sure if I'm doing this right. My company has a Lucidchart training coming up, and we've created a sheet/form that will list out ev…
Hello, I have been having tons of trouble coming up with a formula that will give me the desired result. The goal, it to populate a column with two pieces of information from other columns. In the att…
Hi, I hope you are all well, and someone may be able to assist: On a sheet I am working on, a 3rd party app runs an automation that imports a date into a specified column in smartsheet. The date when …
I found a formula that calculates the years and months between 2 different dates, but because it's not also calculating the days, it is rounding up the months which isn't going to work in the case tha…
Greeting All, I have created a simple index match that successfully matches state/province from my reference datasheet to pull in the corresponding district. I would love to indicate "N/A" for the ins…
I'm trying to write a formula to return a "1" if the reference date falls between two dates. The highlighted Q1 should show a result of "1" based on the criteria further down the sheet as shown below.…
Hi everyone. New to smartsheets and im having issues with my formula. Works fine on google sheets but dont know how to get it working on smartsheet. Please see an example:…
Hi, I'm trying to count the number of accounts using Experiencia with following criteria: Rounding Status is Operational AND EHR Status is NOT Operational. I'm getting an unparseable error with this f…
