-
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…
-
Quarter Formula
I am trying to create a formula that extrapolates the quarter (Q1, Q2, etc) based upon the end date column. Has anyone done this before? Thanks in advance for any help provided.
-
Smartsheet and Teams - open within Teams
This discussion was created from comments split from: Smartsheet Integration for Microsoft Teams apps consolidated and permissions reduced!.
-
Resource Management panel icon - not appearing
Hi, I'm wanting to start using 'Workload tracking'. I've read the learning resource below and set up a new project sheet, however the 'Resource Management panel icon' just isn't appearing. This panel appears to the first step to setting up Workload Tracking. I've reviewed the Smartsheet community, but can't find anything…
-
Email received from Form to say "'user' via Smartsheet"
Hi all, when a user, that a smartsheet and the respective form to be filled out were shared with, fills out the form and submits it, emails received in Outlook say: — that would be me, but other users are the ones filling out the form and submitting it but it still shows my name (since I am the sheet owner). For the above…
-
How to count duplicate Names as 1
I just need help on how to count duplicate names into 1 count vs total number of names. If duplicate just count as 1. Can you help please?
-
Row sorting doesn't work as expected
I have a sheet with a column called Category. This is a drop-down column with options starting with A, B, C, G, L, PL, PP, and S. The items are ordered that way. When I sort the rows using that column, the result is A, C, G, L, PL, PP, S, and B. I have checked for strange characters and the order of the drop-down items and…
-
How to move specific rows without a helper column
I can't add another column to the main sheet to track which lines have already been moved, but I need to move select lines from four sheets to one other sheet. I have a workflow in place that is moving all of the lines that fit the description, but this is causing duplicates on the destination sheet. Using a report is not…
-
Is there a way to remove attachments from multiple rows at the same time?
I have a few sheets I am trying to clean up with attachments saved to each row/entry. Is there a way I can select multiple attachments from multiple rows at the same time to remove them? (Without removing the row all together) Thanks!
-
Identify Time Zone
Hi; I have a sheet that users captures information in, I have a column that records the modified date time, so the column is type of modified. Example Sheet1: Descrption , value , ModifiedDate abc , 123, 2024-01-01 10:50 <--- date time shown in Sheet ex GMT+2 Example Sheet2: Item Name , Value, ModifiedDate abc , 123,…