-
Links in Dynamic View Work Around
Has anyone figured out a workaround to putting links into dynamic view. I am using control center to create a hyperlink to another sheet with display text (for example "West Coast Project List"). This type of hyperlink does not show up in Dynamic View. I am trying to find a work around and was wondering if my best bet was…
-
Smartsheet opens with the same view for a user in a group
Hello, We are using and enterprise version of Smartsheet and within several of the Smartsheets we have multiple user/input. When I open this sheet all of the categories are expanded. Is there a way to set the sheet so that when I open it, it is in the most compact configuration, only showing the top most heading?
-
Update Request Automation
Hi there, I need help please, is it possible to edit a update request? When the update request automation is send, is it possible to only select some of the columns so that the sales personnel not get the whole line's columns but just 5 or 6 of them that they must update? Hope you understand? I know if you send an…
-
INDEX, MATCH, AND formula
I am trying to create an Index / Match cross-sheet formula if two cross-sheet criteria are met. Sheet One displays the Sales Reps for New and Modified Items: I want to display the Item Rep for NEW item types. The formula entered on Sheet Two is: =IF(AND(MATCH(Item1, {SHEET ONE_ITEM}, 0), MATCH("NEW", {SHEET ONE_ITEM…
-
Summary by name and date range
I will try to explain the best I can. I don't have the Pivot app, so wondering if there are any other "tricks" that might work besides exporting to Excel. We are using Smartsheet to log everything that goes through our final testing department. So, assembler, qty inspected, qty rejected, date, etc. Is there a way to…
-
How to retrieve an error file
I made heavy traffic of cell links with other sheet and it was error on my sheet. I could not open the sheet. How to retrieve the file?
-
Idea on connecting two Smartsheets?
I have two sheet that i want to reference and update each other. They both follow similar formatting, with one being more of a log/reference for the other. I would like one list to dynamically update the other. How would i do this? Items list - I have a items list that will show an overview of purchase orders to be done…
-
Backwards Scheduling
I've done some research, so I'm pretty sure I already know the answer. I have a project with a hard completion date. I would like to have any subtask scheduled backward from the completion date. Can that be done in Smartsheet?
-
Reference a date based on Percentage complete
In Sheet One, there are 25 products assigned to 4 Product Types. Each Product has an expected delivery and an actual delivery date. In Sheet Two, we want to add the dates associated with the percentage complete. The existing formulas provide the percentages and totals but how can I add the dates for the milestones. For…
-
custom email message
Hello, can we have a customized e-mail message while we share the smartsheet with the collaborators? Thanks, Bishwo