-
Function for "current user" to use in formula?
Good morning, Is there a function of some sort that I can use in formulas that evaluates to the "currently logged in user"? Use case: I have a Sheet that that has an Assigned To column and a Consult With column, both of which are multi-select Person columns. The Sheet also has a Status column. I'd like to create a Filter…
-
[Control Center] How to rename Intake Sheet? Admin workspace?
Hey there, we're trying to rename our Intake Sheet & wondering what the best way to do this is / anything to watch out for. We would also like to rename our Admin Workspace. Looking for advice before we go messing with anything. Let me know if you need any additional details & thank you in advance!! EDIT: So I went ahead &…
-
Export Column Properties
I would like to be able to export the column properties of a sheet. It would be incredibly beneficial to be able to export the extensive structure: Column Name Column Type Allow multiple values per cell Restrict to list values only Values Restrict to dates only Allow multiples contacts per cell Restrict to list values only…
-
From ESRI GIS to Smartsheet
I came across many articles regarding connection from Smartsheet to GIS, but I'm interested in getting attributes out of GIS and into Smartsheet. We have many program administrators need information from GIS and manipulate it to create and track projects.
-
Export Column Properties
Is there a way to export the column properties of a sheet ? It would be incredibly beneficial to be able to export the structure: Column Name Column Type Allow multiple values per cell Restrict to list values only Values Restrict to dates only Allow multiples contacts per cell Restrict to list values only Add contacts…
-
Better Document Generation Attachment Options
It would be good if we had more control over how Document Generation Attachments are added to a row. We have a use case with two Document Generation workflows – one for updating a PDF during preliminary statuses (New, Revised, etc.), and the other upon reaching Approved status. They each create a PDF with the exact same…
-
Are New Folders No Longer Allowed In Sheets Directory
Not sure when this changed, but it was recent. I used to be able to create folders for organization within my Sheets directory. Now there is no option to do so. The menu options are gone. If I create a folder in a workspace, I cannot drag-and-drop it into my Sheets directory. Right-clicking "Sheets" in the Browse panel no…
-
Ideas on how to effectively create a new sheet that collects information to update status on another
I am struggling to find other answers on the community for this situation. We are creating a log of all equipment. I am creating a second sheet for when that equipment is removed. When someone submits through a form that equipment is removed, I would like the second sheet to automatically update the status on the original…
-
How to Show Serial Numbers Per User in Dynamic View (e.g., 1, 2, 3 for Their Assigned Rows)?
Hi Smartsheet Community I'm working on a project where I’m using Smartsheet Dynamic View to let users see only the rows assigned to them. My setup uses: In the Dynamic View, I want each user to see a Serial Number (S.No) column that starts from 1 and counts upward based only on their visible records. Example: Let's say the…
-
Merged: Description section for sheets and reports
This discussion has been merged.