-
Column Number Function
Hi is there a function that can return the column number when given the column name? This would help when columns are added in sheets that have vlookups referencing them.
-
Delete multiple comments?
Hello, all! We created a copy of a 2020 sheet to make a new one for 2021 because so many of the tasks are recurring; we're merely updating assignees and task dates in most cases. However, we're now left with several comments and attachments throughout the sheet that we need to delete because we copied the full sheet. Is it…
-
Record a Date automation keeps updating to today's date.
I am using the "Record a Date" function to identify an Approval Date when the status of a request changes to "Approved." The automation does record the date once the status is changed. However, once the date is recorded, the automation continually updates the date to the current date. For example: If a request was approved…
-
Sharing Folders inside the Workspace
Can Smartsheet be able to share folders inside the workspace? I know if you share the workspace everything inside can be access, how ever I don't want to share to people all the items inside de workspace and the best way is the share option to a specific folder. So yo can share view to the workspace so the structure of the…
-
Columns do not line up if hidden if referencing 'in' from another sheet
Hello! I am referencing a single row of pertinent information into "Sheet #A, Master" from multiple other sheets "Content Sheet #b"; "Content Sheet #c"; "Content Sheet #d"; and so on. That works, but when I first build the link ALL of the columns in "Sheet #A, Master" need to be unhidden first. This is definitely a rich…
-
Is there anyway to receive responses from a form in pdf?
Hi Smartsheet community, Does anyone know if there is a way to get captured responses from a form sent as a attachment in pdf format? I know you can get a regular email with the responses, but in my case I need to send the response to an exec to do final sign-off via Docusign (I was late to the docusign smarthseet…
-
hierarchy numbering in sheet
Hi Team, Can someone help me how to get hierarchy numbering in sheet for example Project Plan 1.1.1 Resource of Project Plan 1.1.2 Conclusion of Project plan
-
Integrate with Microsoft Access
Does Smartsheet allow for integration with Access database tables? Is this something that a connector is needed for; such as Data Uploader? Will the integration work with older editions of Access or only Microsoft 365?
-
Locked column on sheet is not locked on report
I have several reports created from a sheet that has locked columns. The column locks are not transferring to the reports and now if the report share has editor rights they can change the data in the locked columns. What could be causing this?
-
Inconsistency with copy row automation
Hello! I am running into some issues when attempting to utilize a copy row automation. Sometimes the rows are copied to another sheet, and sometimes they're not. Here's a breakdown of my process... Sheet 1- approval workflow is automated upon form submission, records a date when approval is granted Sheet 2- utilizes a…