-
Count Month from Date Value field
Hello. I have setup a JIRA extract to provide raw data on which to develop an operational dashboard. I need to be able to count 'closed this month' on the dashboard. I am getting a closed date for each row from JIRA and, since this is an automated extract feeding a live dashboard, creating another column to extract the…
-
Parent row based on children status and due date formula
Hello, I have a sheet that tracks event deliverables for 150 or so events each year. The way the sheet is set up each parent row is the event name, and then the children rows are each task for that event. I have a column for Status with the options for Complete, Not Started, and In Progress. I want to create a new column…
-
Want to change our View By in Card View
When I am in Card View I would like to "View by: Assigned to" but the only option is Status. How can I get our Assigned To column when in Sheet View to act as the View By priority?
-
Count(children()) of multiple parent rows
I'm trying to count the grandchildren of multiple parent rows. For example, in the header cell I currently have f(x) = "Salesperson: " + Count(Children()) This is only counting the 4 parents rows I have to designate each market area. What I would like the header to count is how many prospects are in each market area. Is…
-
Assign To - multiple people
Hi, I'm a new Smartsheet user and am also the Sys Admin and support person here in my institution. After some initial teaching, someone asked about assigning a task to multiple people. I thought maybe that would be Assign To a group. However, something tells me that Smartsheet does not allow assign to multiple people based…
-
Resource View / Completed Projects
If a task/project assigned to a person has been checked off as 100% complete before the assigned deadline, is there a way for the Resource View to update in order to show that person being available during that time, without going to the sheet and updating the duration/end date of the task? This way that person could be…
-
Feature Suggestion: Send As Attachment (Columns, Filter)
Currently, Send As Attachment allows for specifying what columns to be included, in the Options dialog for PDF. However, in my opinion, this should be outside on the "Send As Attachment" dialog, so that the specified columns get output/exported to PDF as well as Excel. Further, it would be very much useful, if on the "Send…
-
Conditional formatting in Calendar View
Is there a way to extend conditional formatting to Calendar View? I did notice that if you click on an individual item you can change to desired color. But my project extends over 2FYs and has over 1000 items, so individual formatting is not an option. Thank you.
-
Attaching OneDrive File
I'm having trouble attaching OneDrive files, but have basically narrowed it down to not being able to attach files that were shared to me from someone else. Problem is my boss creates the main folder then shares it with me and we work like crazy out of that one folder. So does this mean that unless I am the creator and…
-
Update email address for contacts does not update shared sheets automatically
Hello all, I have been in the process to update email address for some of my contacts due to the change of domains. However in doing this I realized that all my sheets shared with those specific contacts are not updated with the new information. Let's say that I have already shared or assigned tasks to these contacts. I…
