-
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?
-
Link to Unknown Sheet
We are experiencing issues with "links to unknown sheets" popping up. See image attached. * We are saving the sheet that the link is going to as a new sheet (almost like using it as a back up), but we are clicking so that the "links do not carry over", so it should not be happening from this task. * We have no way of where…
-
Form for a task list
New to this I am trying to create a form with task list on it for site. Screenshot below This will be viewed on a mobile phone. When I create a new form the information (tasks) on the sheet do not appear on the forms. I want the information to appear with the facility for a crew member to tick the box once the task has…
-
Source Table for multiple sheets individual drop down columns
Good Afternoon, I have multiple sheets (50+) that utilize drop downs to look up data specific to an individual record. The individual record for example would be a location number. We add locations on a monthly basis and i need an easy way to update the drop down option from a central location, vs having to update each…
-
Different drop down lists in each row?
i'm 2 hours into this experiment so please pardon my ignorance. I'd like to create distinct dropdown lists for different rows in a worksheet. So the column header is "Color" and the first row is for "Paper" and I have 20 colors to choose from. The second row is for "Crayon" and I've got 100 completely different colors to…