-
How to use IF/AND/CONTAINS formulas with multiple sheets
Hello, I am having a bit of difficulty expanding an IF formula to include a value that is in another column. Let me give an example In this mock workspace I have created basically what I'm doing and what I would like to happen. (all names and ID numbers in this workspace are fictional) In the Training Submissions Sheet, my…
-
Checkbox snaps to Yes/No for random rows
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-click on e.g. Yes it changes to a ticked checkbox. I already tried deleting this whole column and adding it again, but this…
-
Syntax for formula with a checkbox
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, "New", [External:External, "True"]) Currently getting an error: #UNPARSEABLE
-
Does Power BI see checkbox field as TRUE, FALSE, or blank?
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 records when Closed is FALSE and inactive records when Closed is TRUE. Well today a user told me that he reactivated a record…
