-
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?
-
Adding Condition to IF Statement
Hello! I have a smartsheet setup that is collecting data for an asset library. Part of the data is to assign ID numbers when specific values are met. I have 3 columns, I have a stock ID column that is populated manually with tock IDs. Then I have an internal ID column that is auto-populated via smartsheet when the stock ID…
-
Countif Formula in Sheet Summary not giving results
Hi, Just wanted to check with the community if there was any change to the criterion selection under the "COUNTIF" function. I have a column formula for a checkbox column in a Smatsheet that flags if I get a result and the sheet summary calculates if the box is checked using "COUNTIF". I was seeing the results in the past…
-
Data hosting services within Canadian border
Anyone know vendors who can host the data within Canada to meet contractual requirements, since we have datasets built with Smartsheet and running Dynamicview, we are looking for ways to meet the contractual obligations to host the data within Canada by using AWS Canada hosting, basically take all the datasets in the…
-
Is there any way to remove/exclude conversations/discussion from a report?
It seems that Smartsheet is designed to carry over to a report all attachments and conversations associated with each row in an underlying sheet. Is there any work around available? It seems that even if a conversation column were hidden, a report viewer would be able to unhide the column. Thanks.
-
I need a formula that allows the following:
If Modified B has “automation@smartsheet.com” then use Modified By column data but if Modified B is anything else place Modified B data in New Modified By column.
