-
Google Calendar Sync
Hi, I have successfully exported a calendar to Google, however, it is not syncing properly with updates made in Smartsheet - and has an automatic disclaimer posted within the Google calendar Settings that reads: "NOTE: Smartsheet sync is disabled for this Google Calendar." How can I remedy this? Thanks for your help
-
Help With Formulas
I am attempting to automate the RYG column shown in the screen shot below. I need the formula to look at the finish date and status columns if the status is not "Done". I need some feedback on the formula that I am using below. =IF([Finish]1 < TODAY(), "Red", IF([Finish]1 = TODAY(), "Yellow", IF([Finish]1 > TODAY(),…
-
Row Alerts
Hi I am wanting to add a row alert to all rows in my smartsheet, but wondering if there was a easier way of doing this than individually? I want an alert to be sent to the person assigned to the row task, and alerted on the start and due date for their tasks. The alert function on the bottom tab of the sheet only seems…
-
Windows 10 Touch Pad
Can't get the two finger touch pad scroll to work with the Gantt charts. It works every where else, including scrolling through these discussion topics. On for the Gantt chart, the whole chart moves slightly up and down as opposed to the rows scrolling. Anyone else have this problem?
-
Totals by month
Hello, I'm trying to figure out how to get totals by specific month. There are 3 columns I'm trying to pull data from, a monetary column called "Unit Price," a dropdown list column called "Produced," with options that read "1. In Production" and "2. Produced," and a date column. Basically, I want to have a cell that shows…
-
Eloqua & Smartsheet Dashboard
Hi there, My company is new to both the Eloqua and Smartsheet community. I am looking for an easy integration between the two in order to have Eloqua metrics ported over to smartsheet for an easy and clean exporting process. Any suggestions on how this would work or if it is doable? Thanks so much!
-
Sharing Sheet not Working for a collborator
I have a collaborator who I gave access to on a smartsheet, and they have entered data earlier in the day. but now when they try to login, they get a message saying smartsheet not shared. I have deleted the user from the smartsheet and reshared but they are still getting the message smartsheet not shared Can anyone help?
-
Formula - Date Column
I would like to add a second date column in my sheet where the Start Date is manually populated and the new Date Column would count backwards 15 working days and automatically populate. Is this possible? Thank You, Roger
-
Duration Column Doesn't SUM up Correctly
Hello, I am using smartsheet for my master project plan and I repeatedly run into one issue, my project Duration count roll up is inaccurate. I have attached a screenshot to provide a better understanding of the issue.
-
Reminder when items assigned to user
Hi All, This is probably something easy to do, but I'm still a little new to SS administration. I have a issues log that has a "Assigned To" Column (using contact list) and a "Modified Date" (system). I am trying to find a way to send the "assigned to" user a reminder email anytime something has been modified and the…