-
Hidden Column Data Viewable in Export
Hello, I have a table where I hid Column C that has confidential information. Viewers and Editors cannot Unhide the columns of Confidential Information. This is amazing. However, here's the kicker... If the viewer/editor Exports the smartsheet they can unhide the hidden columns. How can I stop that to keep these…
-
Counting using Countifs if a date is present
I'm trying to create a countifs formula where if it finds a date in a column and is a particular county, it'll count that line. I tried this and don't get an error, but it returns a zero which is not correct. Thank you!! =COUNTIFS({McAdvCareSiteReview Range 2}, (ISDATE(true)), {McAdvCareSiteReview Range 1}, "king")
-
Feature Request - Comments and Attachments trigger 'modified' column value
I'm trying to create reports that will show my projects the changes to their workspaces over the past day. I thought a report would do the trick, and I'd just filter by modified within the last day. However, reports don't always catch what you're looking for, like ALL the changes. Report WARNING, the "modified" system…
-
Max value with min collect
I know this is need of a combination of things, but I cant figure it out unless I use a range of cells. I would prefer to search the collective column to perform the task. I want to return the name of the Visit Provider who has the greatest number of SumCompSched for each Phase & Clinic. I appreciate the help in advance.
-
Resource demand, capacity, and utilization management
Hello SS Community! Am fairly new to SS, and was hoping someone might be able to point me to where I might find recommended solutions for resource demand, capacity, and utilization management, using Smartsheet. I know you can use the timesheet template, but it doesn't really do the job of resource management. Thank you!
-
Formula help - due dates falling on weekends
I've got formulas in my sheet that calculate due dates that fall on weekends, and I've used conditional formatting to highlight those dates to alert me to those dates that are on Saturdays and Sundays. Now, I want to move those dates to the Monday next. Is there a way to automate that? Ultimately, I need the best way to…
-
Linking/adding rows using 2 spreadsheets
Hi all, I am having an issue that might be simple to solve, but I can't seem to find an efficient solution. I have 2 spreadsheets: - One with the ID, name, Lot and several other columns with product specification information - Another just with the same ID's, names and Lots, and a few bits more that don't pair with the…
-
Linking cells to a child cell in another worksheet
I have created a Summary Worksheet to capture high-level milestones from a collection of project plans. The way I set up the summary tracker is to create a parent-child relationship under each project and am trying to link the start and end dates from the original project plan to this summary worksheet. The challenge I am…
-
Vlookup
Hello, We have here 5 different sheets containing records for Medical service details, including columns for patient name, ID, DOB, charge amount, payment status, etc. Now i want to get a sixth sheet that will look up from the above 5 sheets only the rows that's stated as Denied, so i can view all denied claims in one…
-
Chart in Dashboards
Hello, Thanks to all for the wonderful help in the community! It makes everything so easy to use! I do have a question about something I was not able to figure out. I want to make a pie chart in a dashboard that reflects the status column in my sheet. Literally all I need it to do is have "Not Started, In Progress,…
