-
Mass producing Dashboard with web content widgets
hello everyone, I created a dashboard to act as a huddle board for the business meetings and we will need about 100 different dashboards but dont want an update on one board to impact the other boards. We used web content widgets and when we "save as new" to make a copy - we are having to go in with the unique publishing…
-
how to set up automation logic for move row based on field value
Hello! I have a sheet populated by a form evaluating items identified by #'s. . There are several hundred items to be evaluated and users may fill out this form several times a year. My goal is to have the sheet showing only the most recent evaluation for each item. I would like to create an automation so that each…
-
Formula Help
Hey guys, I need help to put a formula in my sheet that can sum all 'Type A' column that are from a specific campaign and specific market. for example all total of type A for Jazz (campaign) AT (market) I thought it would be something like, but neither are working =SUMIFS(Campaign:Campaign, "Jazz", Market:Market, "AT",…
-
Is there a way to pull a report or log for Automation Workflows?
I Have an Automatic workflow where once a new line is inserted it emails a contact but it didn't send 1 night and wanted to see if there's audit that it didn't run or if there was an error of some sort. thanks, Sean
-
Hyperlink URL and Display Text from two separate fields?
I have a Form entry that is asking for a (human readable) tag name in one field, and a hyperlink URL (non-smartsheet location) in another. I want to populate a single Smartsheet cell with the hyperlink pointing to the URL, but with the Display Text of the human readable tag... and I can't figure out how to make this…
-
Keyboard shortcut to delete a row
Hi Everyone, I am used to working in excel and using keyboard shortcuts to navigate my sheets without having to use a mouse. Is there a keyboard shortcut to delete a row? if not can how do I let the product team know to add this to the development queue? thanks!
-
Fillable text box isnt show all the information?
Hello, I am having trouble with the fillable text boxes and i dont know what is wrong. I current have the sheet set up so they fill the form out and whats not working is the commas and last number of the salary wont show up on the final PDF. See below for more detail: So I am just wondering if I need a helper column to…
-
COUNTIFS and Duplicate Values
Hello! I need to figure out a way count the number of records in my issue log, EXCEPT if the records have the same parent number, they can only be counted once. Is there an easy way to do this? Is there a way to use the DISTINCT formula in the "Parent" column, but also count the blank rows, as long as the Record column…
-
Data Shuttle Not Adding Net New Entries
Hello! I have set up Data Shuttle with the intention that the PM on the project can attach the daily issue log she receives from our IT department and her sheet would be automatically updated. She document she receives from IT is an .xlsx spreadsheet. I noticed that with each new attachment, the existing data would be…
-
Error message indicating recipients are not receiving automated emails even tho unrestricted
Hello Thanks in advance for any suggestions here. I have set all of my automations to "unrestricted and I am still receiving error messages saying that my clients are not receiving my emails. I have been wondering why I have had such little response. What other options do I have?
