-
Formula Help (does not contain)
Columns "Risk" "Start Date" "Part Status" I want "Risk" to FLAG, if "start date" is TODAY or > and "Part Status" is NOT "shipped" or "in progress" I have the formula below for if start date is today or > =IF(ISDATE([Start Date]4), IF(AND(TODAY() > [Start Date]4), 1)) How can I combine AND if "Part Status" is NOT "shipped"…
-
Adding to an Existing Conditional Formula: Date Field
Good Day All: I am trying to add to my existing formula if the date is not populated the harvey ball will remain yellow. If all conditions are met (date submitted, date approved, approved by committee, and Delivery date) then green All help greatly appreciated, Thanks! Existing Formula: =IF([Approved by Committee]2 = 1,…
-
Using LOOKUP function on a sheet with a form to add rows
I am having some trouble with using the LOOKUP function on a sheet I have. We want to use a form to create a ad placement name that includes abbreviations of what the user selects. I am finding that the LOOKUP area shifts as new rows are added. I set all my lookup tables at the top of a sheet and then the new rows are…
-
Database/Contacts
Does smartsheets include a contact list or database feature and if so where do I find it?
-
Design Error for Resources Allocation - Percentage vs hours/days/weeks
Edit - I may have been a bit harsh calling this a design error, I do see cases it would be easier choosing percentages for resource allocation instead of hours/days/weeks - but making the latter an option would be an amazing improvement. The current design seems relevant for a projectized organization with dependables and…
-
Add a column showing the ParentID (or SiblingID)
Hi all, Is there a way to add a column which displays the ParentID to a Smartsheet? If I had this, I could produce the report I am trying to build I expect. Hep appreciated! Thanks, James
-
tracking Project by the hour
I have started a small project shedule for a job that will take around 72 hours to complete total but with multiple subs having to start and finish at certain times to hit that deadline. how do i change the calendar on the Gant to #1) just show me the 3 day assigned to the task #2) break each day down to a 24 hour time…
-
Multiple Event entries in Published Google Calendar
I've already submitted help to Smartsheet support, but I thought I'd reach out to the Community to see if anyone else has experienced this and what I can do to fix it. I'm fully aware of the limitations of publishing a Smartsheet calendar into Google and have tested it many times. Recently, my department released a sheet…
-
gantt chart labels
Is it possible to assign multiple columns in gantt so I can have both the task and person assigned viewable?
-
Link out to <Unknown Sheet>
Hi, Recently a number of links between two sheets that I use have been broken. It is not consistent (not all of the links were broken). Are there guidelines on why links could have gotten broken? Thanks, Brent
