-
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
-
Filters
Hello, I have a Master sheet setup w Task Names being my customer column. From that I have filters setup for each of my processes which is in the Assigned Column. The filters for example will show all the jobs on the finishing calendar. What I would like to do is setup a filter that would show all the processes for one…
-
Templatizing
I have an extensive project plan with 250 sub-tasks, which is maintained separately for every client. As 95% of the task list for every client rollout, and the time allocated to every task remains the same; is it possible to automate this process i.e. I simply enter a start date for the project, and each and every task in…
