-
Automatic Move Row and External Sheet References
I am having issues with the Automatic move row function and external sheet references. It doesnt seem that the automation will trigger if the formula needs to look up a value from a different sheet. Proofing is not turn on for this sheet. See screenshot for the formula Automation: If cell= "a number", then move to another…
-
Automatically alert when project goes beyond an install date
Hi, We have multiple (50+) projects and once the project commences an install date with the customer is fixed. I have set this up in smartsheet, to have the install with no prior dependancies. What I wont to do is set up an alert when the project build is after the agreed install date. Any ideas on how I can do this?…
-
Colour grading
Hi all, Is there any way that i could, based simply on ascending order of numbers, colour code a full column, as i have in the picture below? Thanks.
-
Every 2 Weeks Alert Not Working
I set up an alert that says send an alert every 2 weeks starting on Monday, Nov 4 @ 9 a.m., the condition is the status must be 'Open." However, it doesn't send. If I sent it to weekly, hourly, daily, it works but the every 2 weeks won't send. What am I doing wrong?
-
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?
