Hello community, I have troubles with one of the checkboxes in my Smartsheet. As you can see (in the highlighted colum) some of the fields show checkboxes, whereas others show yes/no. When I double-cl…
Need help with syntax for a formula for counts. Goal: Give a count where If STATUS field contains string value "new" and where a checkbox named External is checked. Formula: =COUNTIFS(Status:Status, "…
I use the Smartsheet connector in Power BI. I have a "Closed" field in Smartsheet, it's a checkbox. Check it when a record is closed. Then in my Power BI dashboard I have a filter. It shows active rec…