-
CTRL + ] Does Not Indent, But Right Clicking Does
Our Senior VP is having an issue with a sheet where she is unable to indent a row to be a child/sub-task. The strange thing is she is able to right click and indent it, but not using the keyboard shortcut. The keys are working just fine (able to CTRL + C/V, and the [ and ] keys all work individually) but it does not allow…
-
Automate Export to Excel
I am looking at ways I can automate export a smartsheet to excel at regular frequencies. I tried using MS Flow, but the Smartsheet connector doesn't have an option to get to get the content. Any ideas?
-
Project management template packet- Forms Included
Hello, I have generated a 'Project Management Template Packet' to be re-used by Project Managers each time they begin a new construction project. One important item we use is an RFI Form- used by field personnel to generate 'requests for information', which populate a Smartsheet used internally. This information is then…
-
Send only Columns in row with data when sending Notification
Any way to, when sending notifications on a row being added or edited, omit columns that have no data? Say I had an order form with 100+ possible items on it. I don't want to send a 5 page email detailing all the items the person did and didn't order, I want to have the notification only include the handful of items the…
-
Column descriptions for Reports
Does anyone know if this has been submitted for enhancements, or if this option is coming in the near future?
-
Smartsheet login issue
I recently addet a user to my workspace and sent him an invite link, by accident i send a second one shortly after. He opened the website using the first older link (i dont know if that is relevant), now if he logs in he gets the taskbar on the left but the rest is just gray. If he try´s to open the workspace it seems like…
-
Auto fill a second column based on a drop down selection using a form
I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one option from a dropdown of ~100 items. That value then populates into a sheet. (This seems…
-
"Something went wrong" Error
Our team continues to receive the same error message while working in our SmartSheet throughout the day. Though, when we review the SmartSheet Status page there are no similar issues listed. So, my question is: What does this "Something went wrong" mean if it keeps happening for numerous users for almost a week now? Is…
-
Trying to use Time Function to calculate how many days,hours,minutes
I am using this found in the functions list: But Error says #INVALID DATA TYPE. Is that because the columns i am referencing are cross reference formulas and not text/number types? SEE BELOW FORMULA AND SHEET: =DATEONLY([Pending Tech Response Date/Time Stamp]@row) - DATEONLY([Completed Date/Time Stamp]@row) + " day(s), " +…
-
Is it possible to filter out submissions from a form based on if the email field?
Hello, I am learning smartsheets and am unable to find a way to do this. We have a form for one of our sheets so people can submit requests to my team. However, we want the requests to only come from our organization. The form obviously has an option to only allow submissions if they have a smartsheets login but that…
