-
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
-
Duplicate Columns in Report
Hello, I have four different promotional calendars that I am trying to merge into a summary. Each has month/week/day/date columns. When I create the report I want one set of those columns and then the promo/notes/$ etc from each individual sheet. Is this possible? It's very unsatisfactory to have four rows of dates with…
-
Creating a Cash Flow Model
Dear Developer I would like to know if any one be able to help me out (on a chargeable basis) to create a cashflow report that requires the consolidated view from 15 different companies. The idea is that each company has its expenses, incomes, has starting bank balances, different bank accounts, suppliers, customers etc. I…
-
Creating a Cash Flow Model
Dear Developer I would like to know if someone would be able to help me out (on a chargeable basis) to create a cashflow report that requires the consolidated view from 15 different companies. The idea is that each company has its expenses, incomes, has starting bank balances, different bank accounts, suppliers, customers…
