Project Management Certification Study Guide - are the "path" links needed to pass the exam?
Hello! I'm currently studying in preparation for the Project Management Certification exam. Having learned from the Core Exam experience, I'm focusing my studies on the suggested learning material (https://smartu.smartsheet.com/page/project-management-certification-resources). The material so far has been the expected…
Formula - Return month as text from a date cell.
I want to use the formula: =TEXT(*CELL WITH DATE*,"mmmm") But this doesn't seem to be a valid formula on Smartsheet. So if I have a cell with the date "01/01/19" - I want it to show "January" in another cell.
Recurring Tasks - Please.
Please create some kind of button/feature/right-click that will easily turn tasks into recurring ones (like in Asana or Microsoft Project). The amount of workaround hacks needed to get this to work is tiring, and puts off team members who are not as experienced with bullying Smartsheets into doing what they need it to do.…
Can I use a formula to copy the date from my "Target Date" column to my "Projected Date" column?
I'm working on creating a project status dashboard to share with stakeholders at my company so they can easily understand where each project stands. I have a "Target Completion Date" column and a "Projected Completion Date" column. I'd like to be able to use a formula so that when the "Status" column says "In Progress, On…
Nested if & countifs to generate a prefix based on number of occurrences
I am trying to get this part of a concatenate to work but keep getting #unparseable. The latter part of the concatenate works and generates a unique identifier for the project. However, the beginning section is meant to generate a prefix based on whether this project is the first, second (b), third (c) etc. project with…
Project Form - repeating row
I have a project sheet that contains the overall project name as the parent row and the smaller tasks are in child rows. I've created a form to make data entry easier for our team. Is there a way I can make the form repeat the question that asks for the smaller tasks information used in the child row? I'm assuming I will…
Formula to Handle SLA Due Date vs Campaign Start Date
Hi, Smartsheet Community! 👋 This is my first post. Thanks in advance to anyone offering help. Much appreciated! Lots of text ahead but I'm trying to include all relevant details and context. SITUATION We recently launched a new digital marketing request form. On the request form, there are fields for Campaign Type and…
Is the Email Notification highlight color yellow definable?
In a standard email notification for sheet updates the changes are shown in yellow in the email body, is there a way to define that color to something other than yellow?
Introduction - Hello Smartsheet Community!
Hello everyone, I'm currently a student studying at Montana State University and I use Smartsheet to help stay on top of projects at work and at school. When not studying I like to get explore the outdoors with my wife and stare at bison (from a distance). Does anyone have any experience using Smartsheet with multiple…
Quickbooks & Smartsheet
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for invoices): The power of Smartsheet i.e. (approvals, communication, notes) makes this a beautiful…