I'd love to have a condition where cells or columns are hardcoded or locked once critiera is met. Currently the lock feature does not override any formulas, so values can change within a locked row should a formula trigger a change. This defeats the purpose of a locked row in my opinion. Since we have many helper columns…
Hi, I am new to Smartsheet. I am trying ISDATE(COLLECT( function to pull an array and validate whether the values are dates. Is there a workaround? Similarly COLLECT(REPLACE( is there a workaround to modify the array?
This discussion has been merged.
I just renewed my subscription after we chose not to use it for a month and a half. After I renewed the subscription, I am not able to do anything with my sheets and I am view only. I did create the sheets, so I am admin. I was on this account when I renewed my subscription. I do not have 2 accounts. My member status is…
When I access the activity log - it shows everyone who has accessed Smart Sheet in a specific Timeframe. Is there a way to filter to only show people who have accessed it that are in my Internal Organization? I tried using the collaborator field but it only lets me put in my email. When I put in other team members email…