-
How to collect comments from individual sheets, cell-link to a master sheet (eventually Sights)
Hello everyone, For my dashboard (Sights), I show status updates from individual projects. There are multiple updates columns per project I have to pick up. For now, I added extra rows on top of project, and people fill in updates there. Then I cell-link those columns to a master sheet (and create a report for dashboard).…
-
Cell Linking Ability to Filter or Sort Source Sheet / Source Sheet does not stay filtered
All: I have looked but cannot find other questions regarding this topic. Apologize for any redundancy; and, thank you for any help on these two topics. Sandy Ability to Filter or Sort Source Sheet: From my (master) destination sheet, I click cell link icon. Then, I select my source sheet. Is there a way to filter or sort…
-
Linking to other sheets
Hello - I'm attempting to create a worksheet that would be our tracking for specific system setup requirements (checking the box that things are complete). I would also like to be able to allow for approvals, however I don't want each specific field being included on the approval. I was thinking of linking cells to another…
-
Smart Sheet Expert User
Seeking a smart sheet expert user able to to offer consultancy services. Wishing to use the software as a database to read and report on a number of sheets.
-
Software uses
Is there any construction companies out there that use Smartsheet other than for job tracking and HR? Maybe budgets and scheduling manpower? I need some ideas on how to set up those activities on smartsheet. Thanks!
-
Changing the Color of a Font Based on Values
Hi All I'm building a budget sheet and am trying to figure out how to change the color of the font if it adds up to be over budget. For Example: =IF([Column]1 > [Column]2, "Red") But by doing that, it doesn't change the color, it puts in the word Red. Is there a way to do it in Conditional Formatting that I'm just missing?…
-
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…