-
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
-
% Complete in Project Template seems to be off.
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 19% Does anyone have a logical explanation for this?
-
Outlook custom emails
Hi, Is there a way for Smartsheet to capture Requests For Information from contractors and suppliers if they have a dedicated email address for a sheet? I'm new to SS so not sure what is out there. I know there is an outlook plug-in to push content to a Sheet but what if a team member just emailed 'abcdefg@smartsheet',…
