collect contact cells in one cell

mohammad saaideh

mohammad saaideh ✭✭

03/31/22 in Formulas and Functions

i try to give admin access to see all data in dynamic view when using Restrict view by current user

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

03/31/22

You would need to set up a second dynamic view that is not restricted by user.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter
mohammad saaideh ✭✭

03/31/22

I create Automation to assign people and it work , but it used just for a few user , thanks a lot

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

If then formula? or alternative
Smartsheet novice here. I am attaching an image but what I am truing to achieve is this. I have a product that takes 1 hour to install per unit. my team can install 8 per day so 1 installationday. however if the client orders 12 units, it will take 12 hours to install which would be two days, 40 units would take 5 days… I…
Days to go formula
I have a dedicated column "days to go" I'm trying to get the formula to take the networkdays between today and the start date (accounting for dates in the "holiday helper" column. This formula works but gives a negative number. If the date is 5 days in the future I'd like it to read 5 not -5. If in the past be negative,…
Index Formula with CountIFS Running Total
Hi - trying to make a Training Matrix for my company. "Matrix" sheet has the following columns: Row: (Auto-Number) Doc ID: (Text = document needing to be trained on) Employee 1: Check Box if they need to be trained Helper: column formula to give running count of checked boxes =COUNTIFS([Employee1]:[Employee1],…