-
Getting error when trying to use Assume-User functionality to fetch the data of all users.
The Admin account is unable to fetch data for other users incase of the developer account. When we try to use the Assume-User functionality to fetch data by impersonating other users, with the help of an admin account and Oauth2 session, we get the following error. { "errorCode": 1030, "message": "You are unable to assume…
-
Alert Triggered by sum threshold on a specific cell
Hello all, I have a need to alert the person in charge of the spending when the total spending reaches a certain threshold. Actually, multiple levels would be ideal. The source sheet pulls invoice totals from several other sheets and adds them up on a monthly basis. After the calendar month is over, this sheet will…
-
Please suggest a recommended way to fetching data at the organization level with admin user
We need a way to fetch the entire data at the organization level using admin user (Data of all the Non admin and admin users). From the APi documentation and from the below discussion it appears that admin user's oauth2 token is not sufficient to fetch the entire organization's data. Pleas help us with this query. Also…
-
Start date for alert - send on the last Wednesday of every month
Hello, I need to send an alert out the last Wednesday of every month. This is the easy part because I use the 'repeat' and 'repeat on' selection in a custom recurrence. My question is when to start: do I start on a last Wednesday? ie. start today 4/24? Or is the start date irrelevant, because the automation knows it should…
-
Digitally Stamping an Attachment
I am looking to see if anyone has come up with a creative way to digitally stamp an attachment without having to download, open, stamp, save, and upload said attachment. We have an approval process that goes through multiple steps and the final step is a stamp. This is a timely process and I am looking for suggestions that…
-
[UPDATED] Community Reward Program 🏆
Hello Smartsheet Community, We value the way you support and encourage one another and want to recognize your efforts with our Community Reward Program. As you engage with the Community you'll level up and unlock rewards including swag, and access to previews and beta features. Curious? Read on to learn more about our…
-
COUNTIF and CONTAINS in a formula.
Hello! I am trying to count the number of times where a specific phrase is. For example, I have XX - YYYYY as my specific phrase; but some times there might be an XX - YYYYY - ZZZZ or even UUU - XX - YYYYY - ZZZZ. Is there anyway to count the amount of times that "XX - YYYYY" exists?
-
Generate Account User List - API, Power Query, Power BI, Dataflow
Sharing the solution so you won't have to navigate the challenge I just conquered! Need: Generate a list of the Smartsheet users WITHOUT having to download the report from the admin center. Solution: Power Query Assumptions: You're familiar with Power Query, Power BI, Dataflows, and how the PI works. Solve: Create a new…
-
How do I remove myself from a group?
Hi. An unknown individual / party has added me to their group, and I'm unable to exit that group. It's too annoying! Any fool-proof tips please?. Thanks
-
Email address validation
We are sharing a Smartsheet with users across our company and are requesting that those users contribute different data on the Smartsheet. We have noticed that many have not responded and wondered if there was a way to confirm that a particular email is still valid? Is there a notification or something else similar to what…