-
Report on no activity
We have over 500 smart sheets for various processes. We'd like to know which smart sheets have had no activity for the day. Is there an way to create a report for this? Any ideas or suggestions would be highly appreciated.
-
Sharing specific cells when criteria is meet
I would like to have a live display running which displays certain cells as required. We operate a skydive company, and would like to use smart sheets to display the next flight information on a separate screen, The easiest way I can think of is to share certain cells once a check box is ticked. they would then stop…
-
DataMesh - Duplicates In Source Sheet
I have a DataMesh sequence that I run that where the source sheet can have 1 to N number of entries, and it's valid. As I understand it, DataMesh only allows me to select two options - Pick First Match and Ignore Entries. In either of those scenarios, I'm not going to get all of my entries. Is there another way around this…
-
Can I use a different OneDrive account than my Smartsheet Admin account?
We setup a Smartsheet Admin account so that there is no one person owning the Data Uploader scripts, but rather this shared account. This works well. In addition, we have a different OneDrive sign in that we need to use to pull the file(s) we are uploading. This seemed to work one time when the script was built, but it…
-
Create save and Draft option in smartsheet dynamic view
HI Team, In dynamic view, it's possible to share option of save & draft data..
-
Summary formulas not working while using data uploader.
I am trying to use data uploader to populate a sheet. It seems to work fine as far as merging the information, however, the formulas in my sheet summary do not work. See before and after using data uploader below.
-
Salesforce Connector - Filter by current date
Dear Ladies & Gents, is there a possibility to filter by using datetime fields in salesforce and compare them to date literals, e.g.: take only records where a datetime field contains a value greater than the current date? Thanks a lot. Kind regards, Fabian
-
Field Logic in Dynamic View
Hello Community! Is it possible to use the Field Logic in a Dynamic View to hide a row from the view display once certain conditions are met. Example: Once the job status changes to complete, the row hides from the view. Thanks!
-
Datamesh from a summary report
hi! I am trying to build a means to automatically forecast vendor costs, based on a count. I have a large sheet that contains an intersection of many Locations and the Scopes that will be applied to each location. I have different vendors servicing my various locations. I have created countifs formulas to count the number…
-
Calendar App Add On Displaying Section Titles
The app is displaying Section titles and taking up valuable vertical space. and it looks unprofessional as they have no purpose for being there. Please help if you can.
