-
Linking sheets through dropdown box
Is it possible to create a dropdown box which draws it's items from the primary column of another sheet? I am putting together a system for managing the data related to my staff members including workplans, professional development and reporting. On each sheet I would like to be able to ask the staff member to choose their…
-
COUNTIFS formula using dates excluding weekend days
I'm trying to figure out the correct formula for counting up the # of entries for a particular location with a "YES" or "NO" data entry for the previous date, TODAY (-1), that doesn't include weekends. For instance, if today=Monday, then the formula would need to search for the previous Friday date and count the # of…
-
Parent row inheriting status from its children
Hi. I have a number of children rows for each parent. The child rows each have a "Status" column which is using the red, yellow, green icons. I'd like the parent row to inherit the worst case summation of the child rows. E.g. if the child rows are red, green, and green, the parent row would show red. E.g. if the child row…
-
Best practice question
Hello, I'm new to Smartsheet as of this week and am getting the hang of things, so please bear with me: What I have: * Large datacenter project involving nine teams* technology inventory for each team * Risk Register report * Migration scheduling report * Dashboard for project health specific to their team What I want to…
-
Cross-Link Dependencies
2 issues How to cross-link dependencies between separate project management sheets How to see these cross-link dependencies in a summary sheet I looked into these 3 sites for cross-linking dependencies, but I've hit a wall with resource management https://www.smartsheet.com/blog/support-tip-cell-linking-master-gantt…
-
can smartsheet support "comments" and “cell merge”？
Hello, I am wondering whether smartsheet can support "comments" and “cell merge”？ -Cell comments: Write a comments for the value in the cell, like excel? - Cell merge: merge the adjacent cells as one cell - Two level columns headers: Ex: Level 1: Jan Level 2: Qty, Amount, Price Now I can only write header as: Jan qty, Jan…
-
linking rows with attachements
is there a way to link an entire row to multiple sheets along with attachements? or simply link attachements ?
-
Training Plans - Central & Individual
Hello, I would like to build a central sheet that records training courses for my staff. These courses could be assigned to the group or to various individuals. What I would like is to have each individual to have their own training plan sheet, where they could add their own courses and track the courses I have assigned to…
-
Copying Cell Linking
Is there a way to copy and paste a row and retain its cell links to the pasted row?
-
Using formulas to copy, or transfer data between cells.
Hello community! I am looking for a seemingly easy solution which I can't find. While the workflow automation helps in many ways, the "actions" available seem to be greatly lacking. For example in google sheets + scripts + triggers, I can have a cell update based on a formula from a time driven event (whether external or…
