-
Form - Column data entry
I can't believe this isn't asked more often...any way of using a Form to populate data into a new column, rather than a new row? Apologies if this has been addressed previously.
-
Working Days in Dependency Settings with Predecessors
I currently have weekends blocked out in the dependency settings/working days. However If we get behind on the schedule and decide to work a weekend to catch up, how do I add back in a single weekend. I use predecessors to keep the project in the right order of operations. If I manually fill in a date on a weekend and…
-
Is it possible to assign a task to multiple people?
I am running a project where certain tasks are the responsibility of small project teams. As the teams are flat in hierarchy I would like to assign tasks in my smartsheet to multiple (generally only 2 or 3) people, such that they receive reminders, update requests, notifications etc and can update the sheet. Is this…
-
Approval email work around
Working with clients outside of smartsheet, and I want to send them automated approvals. The challenge I am having is the email address that they are receiving the automatic approval from is not from our business name, or specific user. It is a "smartsheet automation" email. Does anyone have a workaround for this? Any…
-
COUNTIFS with multiple conditions
Hi there- I have this formula built to count the number of projects completed within a certain date range: =COUNTIFS({Completion Date}, >DATE(2017, 7, 1) <= DATE(2018, 6, 30)) However, there are five different stages of a project: Completed, Under Construction, Approved, Under Investigation, and Cancelled. I would like to…
-
Adding New Rows
Hi, When adding a new row, I cant figure out the rule for indenting. Sometimes it will be correctly indented the same as the row above it. Sometimes it will add new row as a "Parent" and then automatically make everything below it the "Children" Is this caused by the way I'm inserting, or is there a default setting to make…
-
Saving Indented Row View
I love the Indent feature and especially the CHILDREN() function. Every time I save sheet or switch back from another sheet, my hidden indented rows completely expand & I have to re-click everything to find where I am. What am I missing to make sure the rows stay hidden until I need them? Thanks INB
-
Build cashflow from multiple projects
I would like some help (happy to pay) to enable our company to map task and revenue budgeted for each task and then have the data feed into a cashflow sheet somehow. Could someone help me
-
Integration with contractor connection job track
Has anyone had any success integrating Smart sheet with Crawford contractor connection job track application?
-
Printing gant view
I'm trying to print a gantt chart with the columns that are displayed plus the timeline. The system is only printing my primary column and the timeline bars. I see no settings to adjust this either by printing straight out of the sheet or by creating a report. Anybody have any ideas?
