Sign in to join the conversation:
Since I can't mask/apply sufficient conditional formatting to highlight a improper SS, I've parced it out into various columns and then was applying CF to each particular column. However, when applying CF to the row it doesn't see the 'number' as it's actually a calculation… Is there a way for it to focus on the cell contents rather than the VARCHAR? (e.g., for SS Prefix, the conditional formatting would read 'IF SS Prefix is <100 OR >999 OR not a number the apply this format to the Social Security Number' For some reason, it's not seeing 548 I believe it's seeing the formula that is producing the 548 '=MID([Social Security Number]@row, 1, 3)' Is there a better way to have it focus on the 548 that's in that cell??
I have a sheet set to notify myself and another user when ANY CHANGE is made to the sheet. Neither of us received the notification. Any suggestions on why this is not working? It has been a while since this form was used, but it worked previously.
My reminder in smartsheet automation is set to trigger every day starting 12/05/2025 at 8am (gmt+1) and the condition is to send the reminder to the contact in the contact list if the reminder flag is set to 1 and the status is not one of DONE. Currently on the sheet, a task has the reminder flag set to 1 and the status is…
Hi Everyone, My IT has a lot of confusion on what we access we really need to have for certain people. What is the difference between a "Member" and a "Licensed User?" We have a lot of sheets that have owners who do all of the changes of the sheet. I know that they need to be licensed users. But then, we have a lot of…
