-
OneDrive picker with Sharepoint Sites Support
Hi Smartsheet Team, I am new to your tool and so far I find it very intriguing. I have a question though: We have organized our files in sharepoint libraries. And while I was happy to see the OneDrive support in smartsheet, I was a little disappointed to notice that when opening the OneDrive picker and logging into my O365…
-
Formatting when exporting to pdf
Hi, Is it possible to create a pdf report based on one form entry? I know I can send an email confirming what has been entered on a form, however I would like to make this a pdf attachment rather than the body of the email. Lauren
-
At Risk Flag & IF Function
I am trying to set an IF function to the At Risk column. I would like it to flag if the end date is within 2days or if the % complete task is less than 80%. Can someone help me set that function up? This is what I am putting in; =IF(AND([End Date]3 2>=TODAY() + 1, [% Complete]3 <.8) 1, 0)
-
Workflow - lock/unlock rows
Hello, First of all thanks for helping :) I have this list of tasks where i use my WFIndex + Index columns to identify them and execute automations. My Milestones are "locked", colored in blue and in this case identified by WFIndex = 4 (row 8) I have a few "checks" which i want the user to mark as "completed" before…
-
Creating a User Experience "Nuggets" Database
Hi folks, This article about a SmartSheet competitor, Airtable, has been making the rounds in my little universe of technology products researchers. https://medium.com/@WeWorkUX/the-atomic-unit-of-research-insight-17d619583ba As user researchers, our job is to understand users of our products - their unmet needs, current…
-
ENHANCEMENT REQUEST FOR DATAMESH and PIVOT
Please develop the ability to share Pivot and Datamesh configs. It is difficult for me to support my users when I cannot access their Pivot and Datamesh configs. Also, it makes it more convenient in training users when they can see what I built as examples. I realize I can transfer the config, but that is not always the…
-
Dashboard Widget Chart Issue with Multi Select
I have a dashboard chart widget that was pulling data from a single select option. I've now changed it to multi-select but I see that my chart isn't pulling in that item at all when there are more than 1 item selected. Am I missing something? Is there a formula that I can use to pull in that single option + any combination…
-
How do I find a smartsheet expert for hire to help build out our workspace?
Hello all, I am looking for a smartsheet expert, who can build a project template for us, including a dashboard for internal and external use. We are based in The Netherlands, but we can manage everything in English as well. So are you / or do you know an English speaking smartsheet expert, who we can hire for support and…
-
Webhook callback authentication
i am trying to work with smartsheet webhooks. Would like to use the callback authentication feature as explained at http://smartsheet-platform.github.io/api-docs/#authenticating-callbacks-optional. However, the instructions are not very clear of how to calculate the HMAC value from sharedSecret and request body. For…
-
Backup tool for one user only?
I am using the backup tool provided through the below link with SmartSheet. The issue we are running into is that we do not need it to backup every single user (this is time consuming and bloats to over 3 gigs of data currently). We are looking to keep this more targeted if at all possible. Has anyone had any luck altering…