-
Hiding Columns
I have a sheet that has a column for each day of the year. I go in each week to hide the previous weeks columns, but still displaying the rest. However, since 3/21 the columns are no longer remaining hidden to other viewers, editors, etc. Is there something I can change on the sheet parameters or elsewhere to ensure that…
-
Conditional Formatting on Sheet does not transfer over to report
Basically I have a sheet with data. A row that highlights yellow on a particular condition. This same row does not show 'yellow' in report.
-
Need to automate a pre-filled PDF
Hi folks, this is what I need help with: We have a form where people submit a request for parking pass at our worksite. They give us the info we need, and then a member of our staff reviews their request. Upon approval of the request, and this is where I am stuck, we want to automate such that a pdf is generated with the…
-
Mapping out the logic on a form
I have a form that uses logic in some of the fields and I need to map it all out for others to review and make sure I'm not missing anything. The form is fairly long. Is there a template for a workflow of some sort that might work? I need it to show what happens when the logi is met for a field, and what the smartsheet…
-
Hide fields in customized URL query string
Is it possible to change fields to hidden in the URL string, that are not normally in our forms? I have 7 items that have preset values and can only be requested for a short time each year. Instead of creating 7 more forms (based off the our primary form) I would like to if it is possible to build the url string with these…
-
Automations Using Distribution Lists
Is there any way people have found to use a company created distribution list and have Smartsheet send the automation using that DL? Example: DL_All IT (goes to all IT in the company). Pretty sure that Smartsheet only sees the words "DL_All IT" and not the underlying emails that go with that DL. Wondered if people have…
-
Simple Rookie Question: Import then adding logo
I downloaded the "Generic Job Estimate Template" (Excel version) from the Smartsheet website. I understood some functionalities, such as formulas, may not import and would have to be manually input in the cell. I prepped the Excel sheet with our relevant information in the cells and our logo. Everything came over, except…
-
Numbering Checked Checkboxes in a Column
I have a table which looks up active people on a shift each day. Is there a formula I can use in a helper column which ranks all the checked boxes from 1-9? This is so I can use these numbers to index match all the people active on shift in another sheet.
-
Username Confusion for "Modified By"
I am tracking 400+ projects in a smartsheet that get updated via 25+ reports tailored to filter by project owner. For integrity monitoring I have a report that tells me changes made by timestamp and username using the Created, Modified, and Modified By system fields. My smartsheet has automations, forms, and cell formulas…
-
Cannot sort rows.
Hey there, found similar questions, but none with an actual answer, so hoping someone could help. People cannot sort rows in a sheet, as the options is greyed out. Users in question have "Editor - can share" access, no filters are applied, and the column I'm trying to sort is not locked. Any thoughts on what's happening?…