-
Data displays differently for different users in the same sheet
We have created a sheet that gathers data from various parts of our projects and resource management data. There's calculations in it with conditional formatting to colour the cells based on contents, but nothing more complex than that. It displays perfectly for the owner (via Edge) and another licensed admin (via Chrome…
-
Create sheet with just 1 row per person
I'm trying to create a new sheet that only has one row per Instructor from a master sheet. I have a master sheet of Instructors for my program and it is being updated as Instructors apply to teach courses. I'm trying to create a new sheet with only one row per Instructor from this for a summary and to help with sending…
-
Modified by cell-link@smartsheet.com
Sometimes "Modified by" is captured as cell-link@smartsheet.com ?? we are having formula columns based on modified by column, if randomly smartsheet captures it as cell-link@smartsheet.com, all the calculations are going wrong,...pls advise.
-
Smartsheet Bridge: Get Attachment
Hi, I refer you to Bridge: Smartsheet | Get Attachment article. The Get Attachment module returns useful information like: Attachment Type Created At Created By Email Name ID (of attachment) Mime type Name Parent ID Parent Type Size in Kb URL URL Expires in Milliseconds It returns the URL which allows users to download it.…
-
Formula to count multiple cell values and their dates
I am looking for assistance in creating a formula that will allow me to isolate values in the Provider/Resources cell, the Type cell and count based on Visit Date. Below is the a snapshot of the sheet. As you can see, there are multiple names in the Provider/Resources column, as well as the Dept column. The first name in…
-
Sort Rows with criteria
It would be great if you could use the Sort Row function with a criteria option also. For Example: If I had a range of open and closed requests that have different due dates. Sort rows by "Due Date" with due soonest showing at the top but only the rows where the closed box has not been ticked, the rows that are "closed"…
-
Security & Controls - Content and Chat Controls setting
Good Day All. I would like to change the settings of the "Content and Chat Controls" from "Published sheets are available to anyone with link" to "Published sheets are available to users in the owner's account". I want to do this for all categories. My question is if this will break any of the links we shared so far or…
-
Can I have just one cell automatically copy over from 1 sheet to others when a new row is added
I know there is a workflow for copy row if row is added or changed. I don't want that, since it will copy all of the columns. I have 1 Master List of Names. The other sheets are specific trainings and prerequisites. I will have columns on the master list that don't need to be on the other sheets, and vice versa. I figure I…
-
Smartsheet sending multiple previously updated records for each "on record updated"
I'm using a 3rd party connector to push data to another system when a Smartsheet record is updated. At the start of the day, if I update 1 record, it triggers one "on record updated" event. For every additional change I make to another record, it will be added to the sent events - so if I update a 2nd record and save, it…
-
Subtotal based on a filter in the Grid view
Hi, I am trying to subtotal a number column based on the data returned when a filter is applied in the Grid view? I have tried the obvious subtotal() formula but this does not seem to work, can anyone please help me with this? Thanks