-
What is the best way to create a Pert Chart with Smartsheets?
I don't see an option for it in the "View" button for my project. I did find this article in the help pages: https://www.smartsheet.com/pert-101-charts-analysis-and-templates-more-accurate-project-time-estimates#pert-analysis-how-likely-will-the-project-be-on-time Which says "if you do it by hand" implying there's another…
-
Summary of lacking features
After running a project with multiple sub-projects since june last year, project is preparing/renovation of a eight-floor building for 1300 workers including construction, painting, electrical, lighting, IT, AV, the top three features I have been missing are (no ranking between them): 1. Baseline functionality 2. Ability…
-
Font size inconsistent in Print view across multiple pages
Hi All I have multiple sheets and reports, all the same font & size (Arial 10). When I go to print my reports, some pages show the font clearly, and other pages the quality is compromised/ different font size so my text over different pages looks inconsistent. I saw another thread from 2015 addressing a similar issue but…
-
Sending multiple cards at once?
Hi, I'm very new to smartsheet, so this might be simple, sorry. Basically I have a bunch of applications that I want to send out to different reviewers. Is there a way to send these out in card form (rather than grid view) more than one at a time? So, for example, every application assigned to reviewer a gets sent at once?…
-
Start task next day
Hi there, Is there a way to have a task start on the next day, regardless at what time the predecessor finished on the day before? So like a adjustable lag day (or hours) if you want. Thanks!
-
Looking for a solution to Gantt style planning but backwards from due date
I'm a transcriptionist and I have multiple transcriptions at a time in my to do pile. These all have due dates and I have a good idea of how long it would take to type them up. Ex, due March 1st need 3 days to type, must start by march 26th. If I have multiples due on March 1st, I can't start them all at the same time so…
-
No option to add specific field to form
I am trying to add a system-generated field to a web form. (Created Date) This field will not populate on the form builder. I have tried creating the field within the form builder and within the spreadsheet itself. I am the admin and owner of this sheet. I have successfully added other system-generated fields to forms on…
-
Find date formula
Can anyone suggest a formula to return the earliest and latest date within a child column?
-
GLITCH? Text isn't wrapping nor doing a copy/paste correctly
Good morning, I've discovered that text is no longer behaving well within the cell. I'm see words cut off within the cell, whether or not the cell is formatted to wrap the text. Thus, it makes copying the text and pasting it wonky. I often have to copy/paste text from SS into Word. It pastes with embedded formatting that I…
-
Problem adding countifs
I'm trying to count projects that have either a four or five priority and this formula works: =SUM(COUNTIF({PLT Project Roadmap Range 17}, "Four"), COUNTIF({PLT Project Roadmap Range 17}, "Five")) I want to count projects with either a four or five priority that start either today or in the past and this formula doesn't…
