-
Right-away notifications not being emailed
I have setup a separete hidden checkbox column for each member of our team with a notification to send an email to each person when the column with their name is checked. The email is to go out righ away, when their column is changed. However, I have been changing and saving and no email has been sent out...some are…
-
Gantt rollup for multiple projects
We are trying to rollup multiple project sheets that have tied in metrics. The gantt view is not allowing us to have the dependency arrows on our rollup. Do you have any suggestions how to create this? We have multiple tasks on our project sheets that have dependencies but our phases do not. I tried copying the dependency…
-
Strip Time When Linking Max Modified (Date) Cell to Column with Restrict to Dates
Hi Smart Sheet Community! I am applying a formula to a cell in our project schedule sheets that I found in a couple posts to grab the MAX value of the Modified (Date) column: =MAX(Modified:Modified) + "" My colleagues and I will be linking the cell with this formula from our project schedule sheets to a "Last Updated"…
-
Office 365 (Form) Web Content integration
I am trying to integration a office 365 forum web content link into one of my dash boards. But I get an htttps error but the shared link does us https. Smartsheets says it has Office 365 integration but is it only for certain tools sets within Office.
-
Capturing user/email addressing via form
Relatively new smartsheet form user here. Is there a way to create a field that would allow the entry of a name in one column and an email in a second column and have a user input multiple name/email pairs within a single web form? Essentially, we are creating a web form for training sessions and there are a number of…
-
Multiple choice questions in web form
Is it possible to create a question item where the user can select more than one answer - using the standard Shift or Ctrl keys - or some other way? I'm setting up my first Smartsheet ... Thanks.
-
Formula not refreshing when date changes - Can't tell I'm connected?
Hello ~ I'm new to Smartsheet and would appreciate some assistance. I have a formula that changes the color priority as the next action due approaches or passes, reflecting if the task is pending action from others: Rows that are marked "Done" then gets conditionally formatted to Grey (this was a workaround to not having 5…
-
Sum Values Between Two Dates
I'm looking for some help with a formula. I've created a complicated system of sheets where a contractor enters her/his hours into a form each day they work and I link the data into a contractor's individual sheets which then feed into a series of formulas which feed into reports which feed into sights. What I need to do…
-
Send alert/notifications including headrow and children rows in the attachment
Hi All, I want to send automated notifications to my employees containing their absence records. To do so I need to be able to send their Head row (containing their remaining balance of sick days/holidays/bereavement leave ...) and their children rows (1 row per period of absence) as attachment. So far I can only do this…
-
Displaying multiple column values in Calendar view
I am storing data related to issues in the smartsheets. How can I show the issue number and priority in the calendar view?