-
Collections - Expand Inherited Permissions to Dynamic View
Hi there, Collections was pitched last year as a solution that allowed the permission level of the collection to supercede permissions to individual resources (sheets, reports). Meaning, if you didn't have access to a sheet or report, but had access to a collection containing them, you could still access them via the…
-
Enable Email Automations to Include Links to the Specific Row
When email automations are received, the user has a link just to that sheet and then has to navigate to find the right row, comment, attachment, etc. Is there a way to set up the email automation so that a link to the row is provided? It would save time if the user can click and be directly sent to that exact row to…
-
Automation template not working
I am trying to use the automation template in a work plan sheet, where when I change the project status column to "completed" the "% completed" changes to 100% on the row. I have even tried to reverse it, and say when % completed = 100% change project status to Completed. This seems like a very simple ask, and is a baked…
-
Unable to Count Blank/Empty Cells in a Column
I'm trying to count open/active events that have not been Resolved. Each event is on a separate row with a column called Resolved. Resolved Cells will either be empty/blank or contain a date & time as alphanumeric free text. Example below shows date on top of time in cell (I forced with ALT Enter after date) 3DEC 0859 ET…
-
INDEX, MATCH formula referencing other sheet works incorrectly when matching formula column
Formula that I am using is the following: INDEX({Range 1}), MATCH({Search value}, {Range 2}, 0)). In this formula Range 1 and Range 2 referencing another sheet and Search value referencing the value in the current sheet. The value in the current sheet is also based on formula and when using INDEX, MATCH with search value…
-
Question regarding API deprecation impact on Zapier and Domo integrations
Hello Smartsheet Team, Thank you for the notification regarding the upcoming API changes. We primarily use the Smartsheet API through third-party integration platforms (Zapier and Domo) rather than custom-built solutions. I would like to clarify the following points: Will Zapier and Domo automatically handle the API…
-
Is there an ability to set re-occuring dates in the same row? Calendar/Gantt view
I have several rows on a sheet that have a set date/time each month (i.e. first Tuesday of each month). While i have the durations set for gantt view, I do not see an easy way to add additional dates for the same tracked item? Would I just need to have additional start and end date columns added for each month with a…
-
check boxes aren't updating
Hi all, I send out 3 update requests on MWF. The only one that updates is the Monday one. W+F don't update so I don't have any follow-up. I know that they are clicking on the boxes bc I saw it happen. Boxes on the right are: working on it, done, need help. Working on it gets sent with the W update. Done is the Friday…
-
異なる環境でのアカウント作成について
アカウント作成について質問があります。 現在、１つのメールアドレスでSmartsheetのアカウントを作成しています。 同じメールアドレスで別の環境でもアカウントを作成することは可能でしょうか？ 既に存在するSmartsheetアカウントを削除してから、別環境で作成が必要であると認識していますが、合っていますでしょうか？ 二つの環境におけるドメインは同一のものとなります。
-
Warnings when approaching functional sheet capacity
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…