-
Possible to create multiple linked templates?
Hi All, Hoping there's a few Smartsheet super users out there that can help! I've created a pretty flash client specific dashboard which pulls in from one master project template, which is is also linked to about another 10 seperate report sheets. Without cloning and linking it all up again, I was wondering if there was a…
-
Can Approval Requests send attachments
So I have a process in place where when an attachment is added it triggers an approval request. When the request goes out I want that attachment to be sent via email as a part of this request, is this something that is possible? Currently I am only seeing the ability for the person who approves to add an attachment and not…
-
Automate discussion emails?
Hi, I was curious to know if there was a way to automate the discussions so that everyone within a contact column (or multiple contact columns) could be notified whenever there is a new discussion added, similar to when someone @mentions a name?
-
Locking a Formula in a Column
I created a formula in a column that I do not want people to be able to change, but to still function as people add new information in the rows. By locking the column, will the formula still work (the cell will still populat/update) when the reference cell in the row is updated?
-
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.