-
Notifications with Google Hangouts?
I have Google Hangouts bot activated in Smartsheet and the two bots connected. Despite that, I can't manage to create an Automated Notification that sends to Google Hangouts. Anyone know how to do that? I would expect an option to appear here (see screenshot) like the Slack option does but I can't make it pop up. Help?
-
Different Projects in Different Time Zones/Date Formats etc.
I am US based and the majority of my projects are US based, however, my most recent and my main project at the moment is in Australia, so I have set my Personal Settings for Time Zone and Regional Preferences to Australia. Yesterday I created a new Workspace for a project in the US, and the date and time formats are set to…
-
Checkbox formula causes Contact field to update daily
Hi all, This is an odd behavior, but I suspect someone can help me fix it. I have a task list for multiple projects. Each project has the same set of tasks (pulled from a standard list) but not all projects need all tasks. So, I added a Checkbox column for each row and created a formula. If the box is unchecked, put N/A in…
-
CountIF Formula issue
Greetings, I'm currently attempting to create a CountIF function that counts the number of Ungroomed Stories that start within the next 30 days. My formula is the following: =COUNTIFS([Issue Type]:[Issue Type], "Story", Labels:Labels, ISBLANK(@cell), Status:Status, "To Do", [Target Start Date]:[Target Start Date],…
-
Conditional change to a cell
My sheet is setup with several columns but I need the formatting applied over two of them. Titles are NIGO date and is a date that the item was added to the sheet. The second is a drop it titled Advisor Action Needed and is a drop down list of statuses. I need two things: I need the cell for Advisor Action Needed to change…
-
Logical Condition with forms
Hi, Can we make a logical condition with forms? For example, I have the first selection for Gender and if someone select "male" or "female", it will show different forms for each selection.
-
Update request form after completion/submit not triggering workflow
Hi, I'm quite new to workflow and I'm trying to achieve the following: A document need to be signed by 2 signatories, signatory 1 received an automated update request from workflow 1 which works well. I want workflow 2 to automatically request an update from signatory 2 when signatory 1 has completed his task. I tried…
-
Automation - Open Dashboard as a Trigger
I'm trying to ascertain whether I can force (trigger) Smartsheet to open a Dashboard based on a cell being edited in a sheet. On my Payment Sheet, I have a column that users can select (via Dropdown) to generate a Certificate based on the data in the sheet. The Certificate (Smartsheet Dashboard) formats a number cells…
-
Date and time cell becomes Date only cell on import
When I import a exel file into SS, why does it turn 2020-03-23 08:00:00, into 05/14/20? If there is a way to fix this, preferably from the api, that would be great.
-
Interactive form
Currently I am having a form to collect the timesheet information from different 3rd party vendor. After receiving the data, I am creating a Timesheet smartsheet. I have another master smartsheet which is the collection of all the purchase orders and keeping track of present status of the amount consumed. Is it possible to…