I have a spreadsheet populated by a form where one field needs to be populated using a JOIN of multiple fields from the spreadsheet which are populated using from entry and another needs to be populated by a VLOOKUP. I've tried assigning the formulas to the blank rows ahead of time and using the Change Cell Value workflow…
I know there may be some row alignment or auto-scrolling issues if my browser zoom is set <90% but these things wouldn't impact what I'm doing 90% of the time; however, the message at the top of my screen is relentless and disruptive. Aside from fixing zoom %, does anyone know how to prevent this alert from alerting?…
Greetings! Is there a way to have new rows that are added using the outlook add-in appear on the top of the smartsheet instead of the bottom? Thanks!
I have many project and want to view start date and due date for all project. How can I setting ? Tks
If I set our fiscal year to start in March (which our year does) then the open to today's view in the gantt chart moves one year forward????? If I change this back to January it opens to the correct date. How can I resolve this? Any help with this issue would be appreciated. Thank you!
As I finished working on a sheet last night I got an error message saying to log off and back on. I logged off for the night and now we’re getting the same error message when trying to open the sheet. When we use the search feature it doesn’t appear. When we go to the folder it’s there, but we get the error message when…
I am trying to get this formula to work to return Active if the field Work End Date is either blank or is greater than/equal to today, or return Inactive if neither of those statements are true. I'm receiving an #UNPARSEABLE error though and can't figure out why it isn't working. =IF(OR(ISBLANK([Work End Date]@row), [Work…
Hello, I have a situation where I have a published dashboard and I see an error message that reads " Smartsheet app only, You're currently viewing a published version of this dashboard. This content can only be viewed in the smartsheet app". I tried to remove the widget and another one its still the same. Can anyone point…
Hello! I am stuck and not sure what else to try. I have a master sheet where we collect all of our projects. The Project column is used across several other sheets and we currently have to manually update every time a project is added or updated. Is there a way to update all Project columns in the other sheets based on the…
I really like smartsheet but I've just hit too many roadblocks. If you've had similar problems I'd like to hear what you use in order to scale up to larger amounts of data and also if you've managed to continue to use smartsheet. Thanks! Mike L. 20,000 row limit 500,000 cell limit 20,000 report export limit data connector…
Hi there, I am hoping to find a way for our staff who submit information through form to receive an email confirmation without having to get a copy of the information they fill in the form. At the moment the only email option is to have them get a copy of their response to the form, but I don't want them to have a copy of…
How would one go about getting access to a sheet/form if the person that created it is no longer employed?
Help shape the future of Smartsheet. Share your ideas and feature requests.