-
Search Function not working
Today, for no apparent reason, my search function will not work. It hangs and eventually times out with an error. I've rebooted my MAC and closed and reopened Smartsheet. This is talso rue for another user attempting to search the same Smartsheet. I am in the middle of a critical project that requires Smartsheet data that…
-
Recommended Master Project Document?
Is there a recommended method for tracking multiple projects? A master sheet or doc that shows the status or project of multiple projects? We've done some basic sheet linking but there was no status update and it was fairly manual. It would be great if there was a way to create a line item in the master project document…
-
Sync problems with Smartsheet to Outlook
Hi, I have been syncing my smartsheet to outlook very successfully. Then recently there seems to have been a bug. The calendar in outlook no longer has a title and does not appear on the list of calendars. (so i cant delete it and republish, which is how i would normally solve it) If i go to smartsheet and add the calendar…
-
Smart Sheet for tracking customer onboarding process for Saas company
Hello Smartsheet community members, I am on trial and trying to learn ways to setup smartsheet in order to track customer onboarding process. My company is creating and selling software to customers (Saas) and we are looking for ways to improve our internal communication to help our customer adaping our software quicker…
-
Formula to calculate count of checkboxes in multiple columns and child rows
Hi Everyone, I'm trying to write a formula that adds up the number of unchecked child rows in the Complete column and then subtracts the number of checked rows from the Non Applicable column. The result should be a number of tasks left to be completed from within that parent and child section. I've tried a bunch of…
-
Need to build formula that includes a drop down menu as an option, need advice
I am trying to build a formula that includes a drop down menu as an option. This is what I am trying to do ... =IF([COLUMN1] = "Campus name", then [BUILDING NAME], otherwise "Please select your campus before selecting the building name") * COLUMN1 would be a drop down menu with campus names * BUILDING NAME would be a drop…
-
Web Form Submission Notification
When a web form is submitted, and a record is generatied in my SmartSheet, can I get a notification email containing the Web Form information that was submitted? We have people registering for a conference, and need to know when a new registration is created.
-
Imported Contacts not 'syncing'
I imported an excel spreadsheet that has a column of names. The column was imported as text. I changed the column property to Contact list. As I add people to my account contacts, the rest of the cells in that column with the same name are not sync'ing (?). Smartsheet wants me to add another contact entry. Is there a way…
-
Adding auto-numbered field to web form??
I want to add my auto-numbered field into my web form so that when the confirmation email gets sent it includes the assigned number to that request. Has anyone accomplished this? And, if so, how do I do it? Thank you!
-
Will adding Data unto Webforms be added automatically to the spreadsheet?
How do I get the data I entered on a webform to get added unto the spreadsheet I am working from? Can I do both or does it have to be either 1. use the Webform or 2. enter data unto the spreadsheet?
