-
Merged: Tracking Users' Sheet Views, Edits, Shares... All Activity
This discussion has been merged.
-
Health Icon Formula Help
Hi All - Longtime lurker, first time poster. I am attempting to add a Health Column to a smartsheet created by a colleague. I have been in the forums checking answers to similar, and tried to kluge my own formula together, but I've either missed the logic or I'm trying to do too much. What i'm trying to achieve rollup…
-
Merged: Co-owner of Groups
This discussion has been merged.
-
Project Priority Pull Down Menu
In the Project Priority View it would be great to have a pull down menu option to change the status of a project from High-Medium-Low easily. Currently, you have to open each project page to change the status. Thank you !
-
Allocation constraints per project in RM for multiproject managagement
I am an engineering manager for a group of engineering teams that work across multiple projects. The two challenges I face are that allocations on the smallest possible tasks becomes too much to handle/have overview over and that , if I have PMs for the project, they don't have any constraints on allocation on their…
-
Multi-worksheet excel linked to template for each worksheet?
Sorry, I'm new to SS but trying to see if we can use a single template to build access to dashboard for each worksheet in excel (about 30 worksheets in single file). Ideally, we want to be able to see each dashboard without opening a different file, either by tabs or scrolling screens. But I can't find anyway to do it some…
-
Hello,
I had a formula that was working all through the trials but then right before the roll out it stopped working! In one cell there's a column that Auto counts Responses no big deal there. In a cell in a different column =MAX([Row ID]:[Row ID]) // this counts the largest value so I can record the latest response In another…
-
Today line on Gantt Chart
Is there any work around to make today line darker or more clear when gantt charts are printed?
-
Parent/Child/Ancestor Relationship to Referral Source, Client & Team Member
I am trying to make a relationship between the referral sources who have many referral agents in different counties who refer us clients which are handled by our team members. We track the clients compliance documents in smartsheets. The team member has a set of compliance information we track as welll. They are associated…
-
Vlookup
what is the best way to look up between smartsheets and keep the data fresh =VLOOKUP([Equipment ID]@row, {Equipment Tracker H5 RM 8.8.24}, 1, false) Equipment ID]@row = equipment id this sheet {Equipment Tracker H5 RM 8.8.24} = large data block in another sheet this works but will not refresh if data changes help
