-
Display a message / Instructions if cell is empty
If I have a cell that needs input, like a persons name, but if that info is not filled out based on another column how would I make it generate or display a message? I have column - Plates Made By, I want a message to display if this info is missing. Based on column(s),Column - # of Plate Made, Column - Shift, Column -…
-
Change "From" when sending Update Request
When sending an Update Request, is it possible to change the From person? My sheet was created by someone else but I want to set up a reminder update request that would appear to come from me instead of the owner. I'm currently an Admin on the sheet. TIA! Colin
-
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],…
