-
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',…
-
Ever invented or thought about how to use Smartsheet for the holiday season?
Hi, Im curious about what the community has built or dreamt of building for holiday season needs? templates for sending /automating holiday cards? gift list and shopping? menu/party planning? santa list etc? Im interested in ideas to spread some help and joy via smartsheet this pending season.
-
Resource View by Project
Hi I wonder if anyone might be able to shed some light on an issue I'm experiencing. I'm a new Smartsheet user so I could well be doing something wrong or expecting Smartsheet to work in a way that it doesn't. I'll set out the issue below and if anyone can explain what I'm doing wrong, or if there is a different way to do…
-
Calculate new start time for whole schedule
Hi there! As an event organizer, I want to automatically update my schedule in smartsheet when a session takes longer than expected. Column 1: Start Time (HH:MM) Column 2: End Time (HH:MM) Column 3: duration in minutes Column 4: new start time (HH:MM) how can I arrange a formula so that once entering a new start time in…
