-
Flagging events that share dates
I'm struggling to come up with a way to alert if any other events in the sheet share any dates in common. I'd like to use the "Other Events?" checkbox column to flag if matches are found. And, if possible from there, add another column that lists all the events that have any matches. In the example screenshot, the Dates…
-
Form not populating sheet
I created a very lengthy form that I tested several times before sending it out to colleagues. Now that I've asked people to submit entries into the form, it does not seem to be populating the sheet. I've scrolled down to see if the entries are coming in at the bottom of the form, and I have also checked all filters. Does…
-
Exporting/Importing Google Sheets Not Working
Hi, Exporting to Google Sheets has not been working for about a week. There is no error message, but the dialogue box that pops up no longer has the "open Google Sheets" button and nothing actually gets exported. While trying to investigate the problem, I tried importing from Google Sheets and got the error message, "API…
-
Simultaneous Update of Project and Review Sheets, for Non-Existent Projects, with one form
I am part of a Solution Architecture department that uses Smartsheet to track project reviews. Our workflow involves two Smartsheet sheets: a Master sheet for basic project information (project name, ID, contacts, status), and a Review sheet for detailed review data (review ID, review name, review type, project name, and…
-
Send form via email (not just link)
We have a form (survey) that we want to send out via email (not smartsheet automation because we dont want to share the sheet with the individuals we want responses from). Instead of just sending a link - is it possible to "embed" the form in an email. I have been scouring the net for ways to embed html websites in email…
-
Why is Duration2 in the dropdown in Project Settings but Duration isn't?
Why is Duration2 in the dropdown in Project Settings but Duration isn't? Duration is shown as a column Duration2 isn't! Yet when I change the Column heading Duration to Duration2 I get an Error Message saying Column 2 alreay exists. I need to find Duration2 Column or I need to use Duration to calculate dates. See photo Help
-
Opening Notification in Outlook to open in App not Browser
Is there a way to get these email notifications to open directly in the App and not in the browser? Currently I am using a work around by using the Redirect Add in on my browser to redirect the link to open in Smartsheet, but I'd really like to see this open direct in Smartsheet without hitting the browser at all.…
-
Copying Entire Sheets to New Locations, Keeping Cell History Time Stamps
Is there an easier way to move entire sheets with data, comments, and attachments to new sheets in workspaces housed elsewhere without overriding the cell history's thread showing all changes made to said cells? The Save as New template option moves everything over, but it erases the cell's history and overrides it with…
-
How to resync vertical scrolling in row\Gantt panes in dashboard report widget?
Hello, Dashboard report widget with Gantt view; once the slider bar is moved to expand\collapse the columns viewed then vertical (up/down) scrolling is not in sync between the row & Gantt panes. In the screenshot the blue highlighted rows should be aligned with the Gantt pane. Can this be prevented or resync the row &…
-
Email Automation
Good afternoon! I am wondering if SmartSheets has email automation that sends an email to a client whenever they submit a form. For instance, we have a Marketing Request Form on smart sheets, is there a way to set up an automation where the person who submits the form receives an email from my team basically saying your…
