-
Dashboard Chart to Match Current User Report - Multiple Project Owners
Hello, I have a follow-up to a previous question answered here - https://community.smartsheet.com/discussion/comment/263483 Some of our projects have two owners (two contacts in the requestor cell) so I'd like the charts to reflect the project on each person's dashboard. Currently, I have 1 project in progress and the…
-
How can use the Countifs function with the Today function in the formula?
Hello, I am not sure what I did wrong in the formula that I have created. When I physically count it, I would get 23 but the formula spits out zero. I want the formula to report the number of tasks that was within the last 30 days. Here is my formula: =COUNTIF({Ready For Upload Range 4}, {Ready For Upload Range 2} <=…
-
Is anyone else having trouble with the Today function?
Hello, The Today function is not working when included in a simple IF statement. It was actually working a while ago but now it is not working. I tested it out by simply trying =IF(Cell@232="2",=Today(),"") but it would spit out #INVALID OPERATION. I have even tried =IF(Cell@232="2",Today(),"") but it would spit out…
-
5x5 Risk management formula
Can anyone figure out what's missing in this formula to set a rating from a 5x5 risk matrix. I copied the format from the risk assessment matrix template set that is a 4x3 matrix and modified. =IF(AND(OR(Likelihood5 = "Rare", Likelihood5 = "Unlikely", Likelihood5 = "Possible", Likelihood5 = "Likely"), Consequence5 =…
-
Gathering data from 1000 sheets
Hello, i have this question: We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is: Link this progress number from each sheet to every corresponding line Use that number for further calculations (which is not a…
-
Gannt Chart With Dynamic Income/Expenses Per Task
Hi, I am a contractor and I have all of my draw payments tied to tasks (ex. beginning of drywall) and all my subcontractor payments also tied to tasks (ex. beginning of framing). I'm trying to use my project Gannt to also track my cash flow. I've done this in Excel; however, it was VERY complicated and kept breaking. My…
-
Question on SumIFS
We're hosting a "Bike to the Moon" where our supporters are uploading their daily trips, miles and emails in a worksheet. We want to display a riders' individual trips (showing date and miles traveled) and a total miles field that sums across all their trips (rows.) I'm using this formula at the moment but I'd rather not…
-
How do I pull risks and issues from multiple projects into another sheet?
I am trying to create a programme view over a number of projects. I want to be able to gather all the risks and issues from the various project raid logs into another sheet so, it can be displayed on a dashboard. How is the best way to do this?
-
Notification with Attachments
Hi there, I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true? If so, do you know of any good apps/software to automate that process? I have looked into…
-
Is there a way in Card View to change a task to be a sub-task?
These tasks have a lot of data and have auto-numbering. I was hoping I could drop a card onto another to make it a sub-task or use a menu to make it a sub-task but not yet found anything. There are so many cards involved that it would be time-consuming to rewrite each one as a sub-task. Any suggestions? Thank you, Angie