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 th…
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…
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…
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 t…
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 …
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…
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 …
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 pos…
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…
Working in a Smartsheet Project Template. I've put in my % complete info for each WSB row. The Parent % complete is reporting back 21%, while a selection of the rows shows that the average should be 1…
