-
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…
-
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
