-
restrict data entry of a column to only admin
Hello, Is there a way to restrict data entry of one column to only the admin? but other people viewing the SmartSheet are able to view but are not able to make any changes to the column that is restricted? Please let me know, thank you!
-
Parent Row Formula Based on Children's Status
How do I use a formula in my parent row to update based on the children's status? I want the parent row to to "Active" if any of the children are "Active", "Complete" if all of the children are "Complete, otherwise, "Inactive.
-
the start of a squeeze? what is the community view?
The email below is the start of a squeeze, the direction of which I’m uncomfortable with and which is ultimately designed to force the switch of collaborators into license holders. Removing ‘View Cell History’ from collaborators is a particularly unwelcome surprise. From: Smartsheet Team <productinfo@smartsheet.com> Sent:…
-
Formula Help!!!
I can't get this formula to work. Any glaring mistakes? =IF([Date Received at Settlement Desk]1) = "", "", IF([Date of Payment]1 = "", NETWORKDAY([Date Received at Settlement Desk]1, TODAY()), NETWORKDAY([Date Received at Settlement Desk]1, [Date of Payment]1))) Thanks!
-
Indefinite Lag Times?
Hi, I am trying to set up some predecessor relationships between tasks that don't have a definite lag time associated with it. I just need the relationship to require Task A to wrap up before Task B. Task B doesn't need to start immediately after Task A is done, but it CAN NOT start before. For example, I am doing a…
-
Status Bubble Not Changing Based on % Complete Formula
Hello, I am currently trying to find a way for the Status bubbles to automatically color based on the % Complete column. Reviewing other posts I found and have tried the formula below, but it only works correctly for Red and Grey. When the percentage is above 51 or at 100 the color remains red. =IF([% Complete]2 = 0,…
-
Splitting user stories to new iteration/sprint
For sprint tracking and planning, I'm wondering what others are doing when they need to split a story that isn't finished in the last iteration/sprint. For example, I want to be able to track that the story was worked on previously in sprint 3, was put on hold for 3 months and now is being worked on again in sprint 6.…
-
Removing someone from alerts
Is there a way to remove a past employee from all reminders? I am trying to avoid having to go through each item/reminder. Thank you!
-
Export Dashboards
Hi All, I really need to export my reports and dashboards and the PDF option is too limited. After exporting to PDF and then using a program to convert to PowerPoint or Word, the quality is not the same. We as a company would strongly recommend the option to export reports and dashboards (Word, PowerPoint, etc.) directly…
-
Linking Reports in different sheets
hi guys background: I work for an investment management company. Internally we have about 6 different reports that are interlinked in this manner Report 1: the starting point is an events or presentation calender Report 2: the actual presentation report, where feedback is gathered from presentations that come from the…
