-
Nesting Formulas
I need some help with nesting formulas for the following screenshot: What I'm trying to accomplish is an automatic change in the "Status" Column based on the following criterias: 1) If "%Complete" >= 1% and "%Complete" <= 99% and "At Risk" = 0 then "Status" = In Progress 2) If "%Complete" >= 1% and "%Complete" <= 99% and…
-
moving rows upon completion of task
We want to move completed tasks within a given hierarchy to the bottom of the list allowing active tasks to "move up" Ideas?
-
Calculating output/production of resources
Hi there, I just found out that Smartsheets doesn't have a built-in way to configure the output/production for each person (resource). Has anyone figured out a hack for this? Ultimately, we run a painting company with 40 painters in the field. It is not unusual for each painter to be on more than 1 project during a given…
-
Reoccurring Event
Does anyone know how or is there a work around for entering a reoccurring event one time but have a reminder sent to you every two weeks vs enetering the event multiple times?
-
Graphic for pipeline
Hi, I am an architect and I NEED to see all the data graphically. I am looking for samples of project pipeline graphics produced using Smartsheet. Please, post them here or send me a link. Thanks! ileana
-
cost and efficiency trend calculator
I just started using smartsheets for out development firm. we have hundreds of new consturction homes that we keep seperate data sheets on everything from bidding, to actual cost, to scheduling. I would like to be able to pull the data out of each sheet and generate a report that details how much I pay for each style of…
-
Set recurring tasks, meetings
How do you easily set recurring tasks and meetings in Gantt view and Calendar? Example: Phone meeting or email updates, every 2nd and 4th week of the month?
-
Encouragement!
Good morning, I sent an update request to one of our producers and only included the applicable fields for her to know what needed done. She clicked on the "Open Update Form" button and was quite pleased with it. I also appreciate that Smartsheet then auto-sends a message letting me know what she added/changed. Then she…
-
General Plea for Openness
I would like to ask community members to add some details into thier profiles so that we all can get a better understanding of who you are, what industry you work in etc. The comunity is about sharing, helping and working together and this is much nicer when you know a little about who is asking for the help or guidence.…
-
Best Practices in a large project
I am new to Smart Sheet (and loving it!) I am working with our annual meeting planning which includes everything from location search, contract signing, registration, etc. etc. I can't decide whether this is all one sheet or whether it should be divided into several sections with subtasks. I have played with a bit in…