-
Using HAS with Multi-Selection Dropdown
Hi, I have a multi-selection dropdown with region selections. Next to that column I have the regions. For reporting purposes I need the column for each region to say "Yes" or "No" based on the items selected in the multi-select dropdown. I've created this formula with a variation for each column: =IF(HAS("Central",…
-
Why can't I update Target date in card view?
Is there a way for me to edit the Target date while staying in card view? The only ways I've been able to adjust the Target date on a card is either switching to another view, or updating the Duration. Both of these alternatives are less than ideal, as they require more time and effort than simply updating my new Target…
-
Hidden Columns in Reports - edit, print, send dialogues
Hi. i have built some reports off a large sheet where i have chosen to show only select columns related to the function of the report. I have also hidden some columns within the report. Yet when i use the Edit, Print, or Send dialogue boxes, all the columns from the main sheet are shown. Including the columns hidden in the…
-
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
