-
Re: Calculating time
Smartsheet is not set up for calculation time durations the way it is dates. However, I think I figured out a way to do this even listing times as you have here. First, you need to create two "h…1 · -
Re: Symbol Formula for values
Hmm, the formula looks right. Are you able to share a screenshot of the sheet (with any sensitive info redacted)? Are there rows where the country column shows something other than either "USA&q…1 · -
Re: Symbol Formula for values
That's definitely doable! First, you'll want to make sure your symbol column is set up with all those color options. I think there are options with less color symbols and some with more. Then, you ca…1 · -
Re: Column containing attachment, conversation, etc. is missing on a sheet
It could be a couple of things happening...I know it sounds silly, but first ensure that their screen is scrolled all the way to the left. If that's not what's going on, you might be able to unhide t…1 · -
Re: COUNTIF Date Range with criteria
too many brackets after the AND function. Try this: =COUNTIFS({Audit Date}, AND(@cell >= DATE(2024, 6, 3), @cell <= DATE(2024, 6, 7)), {Auditor Name}, "Brian Lucas")1 ·