-
Cancel reoccurring update requests when complete (or 100%)
Hi All, I might be missing something, but I want my reoccurring update requests to automatically stop sending when the activity they relate too reaches completion. Anybody know how to do this? Appreciate any guidance you can give me. Mike
-
Special formula help
Hi, I'm hoping smartsheet community can help me with an automatic formula. We have a column called "Priority Deal" this is a symbol selection of the stars, where we rate a specific land opportunity (empty/one/two/three/four/five) I'd like to create a formula when a specific star is selected, the column "Deadline Date" is…
-
Report assigning random background color
I have a report that pulls in data and then, for some reason, applies a yellow background color that is not found in the original sheets. I found a 2016 discussion with a similar problem. The Smartsheet rep said it could be old data, so they refreshed the db? Is that the same case here? Thanks in advance BK
-
Report Publishing...
I want to be able to publish a report link for editors to update a project status the way I can publish fully editable links via the sheet itself. Why can I only publish secure links for reports that require a login? I want editors to have access to change information in a report without logging in. What am I missing?
-
Checkbox tick then auto highlight certain columns?
Hi, We have a sheet called project milestones for managing the steps of LIVE manufacturing an installation projects. I'd like when our production manager selects a tick box on a specific row, that 4no columns within the row are automatically highlighted light green. The column "In production/ Approval Docs uploaded" Should…
-
Auto Populating Report or Sheet with New Rows from Master Sheet
Hello- I'm trying to figure out how to automatically pull in new rows (either using cell linking or reporting) from one sheet, while having columns editable from another sheet. For example, I have one sheet that is a master list of all projects in my organization. We continually add new projects to this sheet. Each project…
-
Transferring Sheets to a New Smartsheet Account Owner
I have a client that we developed specific Sheets for on my Smartsheet account. Now that my project with them is coming to a close, we want them to start a new Smartsheet account and transfer the sheets we developed on my account for them, to their newly established Smartsheet account. These Smartsheets were developed for…
-
Collaborating on Single Task with Outside Vendor (Rehab)
Greetings. I have a Real Estate Property "Rehab Project Plan" with tasks that I would like to assign to a vendor (i.e Electrician) so that I can manage his tasks and collaborate with him. I do not want the Electrician to see entire sheet, only that task(s) assigned to him. I have read several articles on this but couldn't…
-
Smarter Dropdown List Manager
Further to a considerable amount of Community requests for a way to Update Dropdown Lists in just one sheet, then have that list Automagically populate all the other Smartsheets that reference that list. Our Developers, using the Smartsheet API have created just that solution, in fact we have assumed that users will want…
-
View Ranges Used in a Sheet (or all sheets)
Hello, I would like to know where I can go to make edits to some of the ranges I created. Normally, I can see the ranges I have created by just clicking on the cell once (rather than double-clicking to edit), but my formula is too long and it pushes the range links off the page. Please see attached screenshots. Any help…
