Is there a formula or function that will check/uncheck all boxes in a column if one box is checked/unchecked.
For example if top box is checked, it will check all the boxes in that column?
You would use a basic cell reference in all of the other rows.
=[Checkbox Column Name]$1
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
Would like the choice to be able to chose specific boxes or all boxes at once.
Ah. Unfortunately it is going to be one or the other. You cannot have a formula as well as manual entry within the same cell. One will override the other.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi need help in calculating date based on the cell value in "Grouping" If Cell value in grouping is "A" then add 45 days to the date in "End date" for the date required for populating next cycle count schedule. If Cell value in grouping is "B" then add 30 days to the date in "End date" for the date required for populating…
Just looking for a the formula to count the parent rows from the primary column. I dont need the children in this case.
Hi I have create a formula to calculate the % of margin but when i apply this to the column and there is current data, I get #DIVIDE BY ZERO. my formula is =[Margin $]@row / [Forecast Amount $]@row appreciate any help, thanks
©2024. All Rights Reserved Smartsheet Inc.