-
Trying to fix the start date of a subtask with no dependency
I trying hard code the start of a sub-task (4th level indent). When I try the start dates always comes back to the start date of the task of the previous indent. I would like to have my sub-task with no dependency to start much later (hard code the start date). Any suggestions? Thanks
-
Is there a way to run a report on a user's activity?
I know I can run their smartsheet access report but that doesn't give me the information I need. I think the best way to explain what I am looking for is to give an example. I am trying to create dashboards for some of the executives so they have their most used smartsheets all in one place. The user access report says…
-
Array formulas
Hi, I was looking for using array formula functionality in smart sheet. I need this because i saw that like this i can full fill what i need. Any case, could you please mention if is a way to use array or other solutions in order to perform: - I want smart sheet to show me in a column date, the first date, closest that…
-
SUMIFS & FIND functionality with Summary Sheets
Hi All, I checked the archives and couldn't find a solution to my problem so I apologize if this has already been asked. I am trying to create a formula for my Summary Sheet that will provide the sum of dollar amounts but only if they are "Cost Savings" or "Risk Management". I am also trying to create a formula for just…
-
Project planning for an Agile development
Hi, I would like to understand how do you prepare a project plan for an Agile software development. I understand that first the product backlog needs to be created containing the list of features/bug/enhancements that are needed for the release and subsequently during the Spring planning, the tickets are discussed with the…
-
Tracking date when a drop down value is selected
I'm creating a project tracker where I can assign what phase the project is at (design, prototype and complete). What I want to do is track how long the project is in each phase, so what I plan on doing is tracking when the drop down items are changed. I thought of using an IF statement where if "design" is selected, then…
-
Help For Colorblind Folks
Good morning! I struggle with trying to pick the appropriate colors from the fill and text palettes due to red-green color blindness. Would it be possible to have a text bubble with the name of the color pop up when you mouse over each color in a palette in any area of the application? It would be a huge help when…
-
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…
-
Where can I find a smartsheet's consultant??
Looking for a consultant to help our business maximize how we currently use Smartsheet. Needing someone with expertise in offering opinions and solutions for our needs. We are wanting to revamp our processes and utilize the dashboards, reports and automations. Would love someone that will offer guidance and that will build…
-
Dropdown list - Update from the dev team ?
Hi everyone, TL;DR : When will we be able to have dynamic dropdown for a column / field in a form? Is there a workaround? I can't think of a single project where this CAN'T be used... I'm using Smartsheet more and more to provide simple solutions to my clients regarding their work (finance, managing team, project...). I…