-
Re: Need help with "IF" statement...
Just saw your latest post, glad you got it to work. 👍️1 · -
Re: Finding duplicates
Hello SamprasFederer, The issue you are having is that Smartsheets adds an apostrophe to the front of 0's, so 020496 is actually '020496 so it is treating it as a text string (click in the cell and v…1 · -
Re: I am trying to Set up a 'Turn Around Time', but I am getting '#InvalidColumnValue' or 'Unparseable'
Hello Kayleigh, Could you provide more context? I setup a similar sheet: Column Breakdown: [Log In Date] column is of type Date [SLIM Approved] column is of type Date [Days Took] column is of type Te…1 · -
Re: If this and this match then yes - reference other sheet? Range issue?
Hello @Simon20444, I came up with this solution, and I hope it helps. In the sheet called "Restock Sheet" I have these data and columns: In the sheet called "Audit Sheet" I have t…1 · -
Re: Formula to book 30 minute time slots based on event duration
I was working on a similar project and was stuck on this for a couple of days. This was a lifesaver. Thank you @KT_H you're awesome.1 ·