-
Mysterious Date Changes... Dependencies and edays?
Hello, I've had a few users reach out to me today about seeing changes to their project plans, but no one went in to change dates. The activity log was clear of anyone specifically doing anything to affect the start and end dates. The recent user, after investigating her plan, had a predecessor (our dependency column) that…
-
Connecting Automation to conditional formatting
I am trying to figure out a way to attach automation to conditional formatting. For example, I have 4 columns, with the last one being a checkbox or another standardized trigger. I want to send out a notification that a row has been added, only when the checkbox in the last column is clicked. I set that up already because…
-
Weekly/Monthly Status Reports
Hello smarties! I hope you all are doing well. I have a new situation that I wanted to start with you all to see how you would handle. I have a new situation where we need to supply a Weekly/Monthly Status Report. I know that I could build this in a dashboard (I also plan to do this) however is there a way to "save" or…
-
How do you create a dynamic list of unique values from multiple sheets?
I am trying to create a "level of effort" calculation where we compare the count of bidded, lost, and awarded projects against a specific criteria, which is often a dropdown column in the source sheet. I have tried using JOIN, COLLECT, and INDEX from at least a dozen posts in the Community but nothing has worked to date.…
-
Anyone have a BRD Template?
Looking for a BRD template that someone may have built and wants to share.
-
Dynamic View Link Access for Non-Smartsheet Users
Hello, If I send a link to my contact list (using an automation workflow) of a dynamic view I created, will the contacts that that currently don't have a Smartsheets license be able to view that link?
-
Requesting Status
I am an owner and an admin. Why can i not request status?
-
Owner of the sheets but only have Viewer access right
I have subscripted Pro user plan and currently work on 3 sheets. Two of the sheets suddenly not allow me to EDIT and I can see I only a Viewer of the sheet, but actually I am the only member of the plan. Really don't know how to fix the access right to be admin of those sheets.
-
Reports - How do I add a specific cell from every sheet
I have a workspace that has several sheets and I want to create a Report that shows me the cell Column5 row 6 from each of those sheet, and if the content of that cell is equal to a specific content, then i want that sheet to be on the report. After that I want to add Column6 row 3 to the report from every sheet that met…
-
Does SmartSheet have an equivalent to Excel's "Name Manager" and "LAMBDA"?
I need a way to label a specific set of data or create a custom function that can be used in cross-worksheet formulas. Related to another query of mine, I need to take a list, give it a specific name, and reference it without having to navigate to the source sheet every time it's needed. For example, let's say I have a…