Hi @palmcitytim If you're searching for one value within a multi-select cell, you can use the HAS function! For example, something like this: =COUNTIF({Multi Select Column}, HAS(@cell, [Single Name]@… (View Post)

I'm not sure I follow. Are you looking to pull one row for each unique instance and then add a count for each of them? (View Post)

Thanks! I was able to do a rollup sheet with percentage of completed items shown (pulling from each sheet). Then pull that rollup sheet into the dashboard. The dashboard is a little more automated th… (View Post)

Hi @ntpss Try using an IF statement, like so: =IF(WEEKNUMBER([Date Column]@row) - 26 > 0, WEEKNUMBER([Date Column]@row) - 26, WEEKNUMBER([Date Column]@row) + 26) It will either subtract 26 or add … (View Post)

Changing the order of the pieces within a formula will not change the number of references because you are still referencing entire columns. Same with #2. The references are still there, so you are s… (View Post)

Hi @JillRube For security reasons, it's currently expected behaviour that alerts sending out to third parties (such as Teams or Slack channels) need to be manually reset/configured for each new sheet… (View Post)

Thank you, all! This one worked like a charm: =IF(MONTH([Finish Date]@row) <= 3, "Q1", IF(MONTH([Finish Date]@row) <= 6, "Q2", IF(MONTH([Finish Date]@row) <= 9, "Q3&… (View Post)

@Lucas Rayala Conditional formatting will also have a large impact on sheet speeds. (View Post)

Hi @naeem.CHG If I'm understanding you correctly, you need a way to bring in the Account Manager name into this sheet based on two criteria: the Date in the Max Date column and the Client. Since you … (View Post)

Hello @Trond At this time, that specific formatting for date is currently not available but it is a really great idea! Please submit an enhancement request on this to be considered for future develop… (View Post)