-
Duplicate a Datamesh
My team depends on a series of "working" sheets (target sheets) that have a set of predetermined columns that all populate data from a central "data" sheet (source sheet). The data sheet stays static, but the working sheets are frequently added. The ability to duplicate a datamesh and simply change the target sheet would…
-
Adobe Sign Intergration
Hello! Is there a way we could use the "Generate Document" feature/integration to request signatures from third parties directly from Smartsheet? My company only uses Adobesign, not Docusign. Thanks!
-
Best practice to notify/ask if someone's name is selected from a drop down?
Greetings- I'm trying to figure out if the way I am doing it is the most streamlined way. I have a column called assigned staff where someone can select a single individual or multiple staff members. Once selected they are emailed with info from the grid asking if they are free during form submitted time (ex meeting time).…
-
How can I disable comment & collaborate options for all Free users in Smartsheet?
-
Formula in % Complete column
This discussion was created from comments split from: Auto update % complete.
-
Dynamic Sizing of Dashboard Widgets
There are many times we show data within report widgets and there is a of whitespace due to not many things being in the report. The suggestion would be to have the widget adjust its size based on the number of displayed rows. Two things that would make it even better... Have a checkbox that allows setting to dynamic, in…
-
Help understanding the new user subscription model
TL;DR In the new model, is it possible to have people outside your organization edit sheets without having to pay for them (or do some kind of weird change in permissions and re-share every 3 months)? We are trying to understand what the new user subscription model means for us. We are a small consulting organization that…
-
How to set up an automation that is based on an if statement?
Hello! I am trying to set up an automation that changes a cell to "Complete - Pass" when four different conditions are meet. The way I am doing this is by adding and additional column that does a pretty complex if statement, and from that it either returns "Pass" or "Fail". =IF([QA Filter FAIL]@row = "Fail", "Fail",…
-
Help with SUMIFS
I am trying to collect the numerical value based on whether or not work was completed between two dates by a specific employee that was assigned to the work, using SUMIFS. =SUMIFS({Numerical Size 1}, {Date Task 1 Complete}, >={Week 1 Start}, {Date Task 1 Complete}, <={Week 1 End}, {Assigned To}, Employee@row) ALL results…
-
Cross Sheet Reference Shows #REF When Row Is Moved
I have an intake form setup in one sheet and in another sheet I have a bunch of formulas to format the data from the form into a csv that can be used to upload the information into Jira. I have everything working, except when I have the row removed from the intake sheet (because it's been completed) I get #REF in my sheet…
