-
Possible to create Gantt Chart in duration of "hours" for single-day projects?
Hi, I created a project smartsheet with gantt dependencies in duration of "hours" for an important project that lasts one day. I was wondering if there is a way to create a gantt chart that only displays one day but shows durations of "hours" on the x-axis instead? (The current gantt chart I see only displays 30 days…
-
Task names in Gantt are gone
I was updating my sheet yesterday and payed no attention but this morning I've noticed that all of the task names on the Gantt chart are gone and I can't seem to find a way to get them back. Any ideas? Thank you in advance!
-
Populating webforms with data from sheet
Hi friends, I will try and explain what I am trying to achieve: I have an issue tracking sheet with columns effectively divided into 3 sections: 1) Originator raises an issue on a webform, on clicking "submit" the sheet is populated. This works fine. 2) A webform is then created from the cells in the row corresponding to…
-
Reminder when items assigned to user
Hi All, This is probably something easy to do, but I'm still a little new to SS administration. I have a issues log that has a "Assigned To" Column (using contact list) and a "Modified Date" (system). I am trying to find a way to send the "assigned to" user a reminder email anytime something has been modified and the…
-
Totals by month
Hello, I'm trying to figure out how to get totals by specific month. There are 3 columns I'm trying to pull data from, a monetary column called "Unit Price," a dropdown list column called "Produced," with options that read "1. In Production" and "2. Produced," and a date column. Basically, I want to have a cell that shows…
-
Allocations
Scenario 1 I have a task that happens every Tuesday but only takes 1hr of my time. I don’t want to create multiple rows to indicate this as one 1hr of the day, is there another way to do this? Scenario 2 I have task that happens with a span of 5 days but only takes 3 hrs how do i calculate that? Is there a way to do this?
-
Nested Formulas issue
Hello all, I am currently working on moving some trackers into sheets from excel and I have hit a roadblock with the following formula which works in excel. I have looked at the template formula sheet and I can get them individually to work however not together. Thank you in advance for any help. =IF(J6>0,"Task…
-
Web Form - Signed
HI all I am creating an onboarding web form however we need the form to have the ability to be signed, I know SmartSheet has an app with Docusign but this is very expensive Does anyone have any tricks or ideas of how this could be done Thank in Advance
-
Can I add a formula to a drop down list cell?
I currently have drop down list that contains, "Not Started", "In Progress", and "Complete". What I would like to do is add a formula that automatically changes the drop down list from "Not Started" to "In Progress" if the Duration cell has been changed from 0% to anything non-zero. Is it possible to add a formula to a…
-
Creating and editing schedules in Calendar View
Hi all, I am just wondering if there is a way to visually create and edit a schedule in Calendar view. Such as dragging dates and durations like we do with Gantt bars? Darin Schnitzer
