-
How can I count the amount of actions in one specific month?
Hi, I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month (May), I want the counter to return "5". I've been trying to use the formula below but all I get in return is a zero: =COUNTIFS([Target Due Date]:[Target Due Date], IFERROR(MONTH([Target Due Date]1),…
-
Counting amount of actions in one month
Hi, I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month, I want the counter to return "5". I've been trying to use the formula below but all I get in return is a zero: =COUNTIFS([Target Due Date]:[Target Due Date], IFERROR(MONTH([Target Due Date]1), 0) = 5)
-
How can I compare two date columns in an automated workflow?
Hi! I want to create an automated workflow which copies rows where two date columns are not equal to another sheet, how can I do this?
-
New Admin Center - User Management
I like the update of the new "Admin Center" for controlling and editing users and groups, I accidentally clicked on the little graph with a down-arrow icon and got an email to download the user access data. It would be helpful to have a little tooltip for these, not only for the sake of our edification, but as part of the…
-
Use data from a form field in the alert email title.
Setting up an alert system that sends out notifications when a form has been completed. To streamline the process I would like to use a field from the form in the email title to differentiate between the emails rather than a range of emails with the same title. Is that possible and if so, how? Cheers
-
How can I retrieve deleted approval request email?
hi, I have a work approval request flow that being used to our department for document approval process. We have one manager who accidentally deleted the approval request email and we don't know how to retrieved it since it was gone in to the email deleted folder. Is there a way to retrieve an approval request email? how?…
-
How do I hide names in Gantt Chart?
I created a schedule and assigned task to the resources names. The names are showing up in the Gantt chart. How do I hide names ?
-
At Risk Flag & IF Function
I am trying to set an IF function to the At Risk column. I would like it to flag if the end date is within 2days or if the % complete task is less than 80%. Can someone help me set that function up? This is what I am putting in; =IF(AND([End Date]3 2>=TODAY() + 1, [% Complete]3 <.8) 1, 0)
-
User name changed after few minutes in sheet.
A smartsheet is shared with me. Whenever I create any record and attached file, I got my user name and time with attachment. But after few minutes the user name is changed to name of the user who shared the sheet with me. it's happning with all user if sheet is shered with them.All files show only single user name. Kindly…
-
Share Dynamic View to Email Address
Hello, I have added the email address for a specific Dynamic View I would like for them to access. Now what? How do I point them towards the Dynamic View so they can gain access and see it? Does Smartsheets send them an invite email automatically? How does this work?
