-
Automate image attachments to drop into a column
Hi, My team is asking for images to be visible in a column versus as an attachment. Unfortunately one has to click on each attachment to view. One cannot see a preview of all images on each row on the sheet. Therefore one has to open attachment, preview, download and insert in to a dedicated column with cells for pictures.…
-
Nested IF, INDEX, MATCH formula returning invalid value
Using the formula =IF(UPN@row <> "", INDEX({Cardinal Metadata - UPN & UPI List 'EI&C'}, UPN@row, MATCH(UPN@row, {Cardinal Metadata - UPN & UPI List 'UPN'}, 0)), "") to return the email address if the UPN is not blank in the destination sheet, eliminates errors if the look up sheet has an entry in a blank row, I get invalid…
-
My Smartsheet won't save!!!
I have tried everything, new browser, clearing cache, updating browser...this sheet only has 51 lines and no advanced formulas. Why won't it save!!!!???
-
Update field is missing in smartsheet update requestf
Hi, Some of the users report that the automatic update request emails don't allow them to provide the actual update. The field for providing an update is missing (please see the attached screenshots). Could you please let me know of the reason why this field is absent for some users? And what can I do to prevent this from…
-
Developing an invoice with something other than Google Docs
We've been using Smartsheets for several years now for individual/residential property management. At the end of each month, we create an invoice listing out the services rendered at each property (what items were checked in each home, how many times they were checked, who did it, what needed repairs, etc.) We've been…
-
Reports Not Updating
Hi Smartsheet Community, I may have found a potential bug related to the recent release. Some of my reports are not updating as expected and I have checked my source documents for the helper columns that are tracking tasks that were due the previous week, due this week and due next week. The formula is working…
-
0s on my charts
Hello - I'm creating basic bar charts and right now they look cluttered. How do I show the data values EXCEPT when that value is zero? I tried using the 0 formula on the source sheet, but it still showed up on the chart.
-
Row # reference within notifications in Smartsheet app?
Does anyone know if there's a setting or if it's even possible to have the relevant row # shown/referenced when reviewing a notification within the Smartsheet navigation bar? The row # is referenced when you get an email notification, but the same notification within the SS nav bar doesn't include this information (see…
-
Can you alert/send an email to contacts in a cell that have been entered via a form?
I have my alert settings to Unrestricted, but even so, it seems those who fill out our form cannot be notified since they are not users of SmartSheet. I am looking for a solution other than the "Send me a copy of my responses" option. TIA! 😁
-
Getting a fillable PDF to auto fill once a Smartsheets form has been completed
Hello! I'm trying to get a fillable PDF to auto fill once a Smartsheets form has been completed. I have automation turned on to generate a fillable PDF, but it's blank. Is there a way to have the fields in a given row auto-fill a generated fillable PDF? If so, how do I do that? Thanks!