-
Link Cells - Anyway to update data on either sheet
I use the cell linking extensively, however it would be so very helpful if cells could be updated from either sheet... For example, I have a master project sheet that consolidates lines from mulitple projects in sepearte sheets. However when I want to make a change to one of the lines I have to go to that projects sheet…
-
bi directional linking
is it possible to setup cells on 2 different sheets to update each other? (either cell updated will relect on the other)
-
Row ID
Hi, I would like to be able to return the Row ID of a given column - to use in the following formula: =ROWID(ANCESTORS([Task Name]1)) Which should return the row ID of the first ancestor (Parent) or the current row. If there is no ancestor, I assume it would then return null or 0 Does a function such as 'ROWID' or similar…
-
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
-
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
-
Can I create a If Then statement using a date in smart sheet?
I am trying to get a summary of duration for a particular resource within a particular month in smartsheet. This is unfortunately so that I can then input the hours into a custom ERP that lacks any intuitiveness. How could I do this? Here is an example Resource . Duration . Start Dates, End Dates LD 2 days . 8/29 8/30 AD 1…
-
Automated linking of added rows
Hi! I seem to have a major problem here and hope for you expert advice. My situation is as follows: 1. Team A and team B work collaboratively in Masterfile on first phase of the project with over 200 rows from all countries. 2. Team A also works with the other 7 country teams on a second phase of the project. 3. All teams…
-
Modified Date by Cell not row
Hi, I have a use case where I need to apply current date when a specific cell is modified--not the entire row. I understand there is cell history, but need this cell modified date visible as a value in the sheet. Thoughts? Thanks, Sean