-
Publish Calendar View
Is there way to publish the calendar view only? I am needing to share just a bit of data in a calendar view only without sharing the entire sheet. Thank you in advance for any help.
-
Setting Up Approval Flow from WebForm
Good afternoon, I created a webform that useres could input data to even though they may not have a smartsheet account. Is there a way for any user to submit the form, and then have it come to me directly for approval before populating the sheet?
-
Alerts & Actions - Update Request
With the new feature to send update requests automatically (Awesome feature by the way), I've noticed a few draw backs to this option: * the request no longer grabs the primary column information but the sheet name. This makes the request pretty generic to the recipient instead of specific to that row * There is no ability…
-
Date Countdown Formula
I need help creating a formula in a sheet to countdown to a deadline. Essentially, we have a deadline for a specific date, and a few milestones that we need to see a countdown based on the final date.
-
Unable to access specific sheets
Hello, Has anyone lost access to a sheet due to a generic Ajax error and had it successfully fixed? We have a Enterprise account with hundreds of users, yet none of us are receiving timely communication or any resolution plan from Smartsheet support. Have any of you run into this before? I am very concerned we are going to…
-
Reviewing Alerts & Rules for errors
Hi all, I've searched high and low but I can't find a way to do this easily. Is there a way to export all the notifications and rules set up for a sheet for ease of review against the process? Basically I want a report of all my notifications and rules layed out in a table so that I can review them against the process for…
-
Conditional Formatting
Hello, Is it possible to apply conditional formatting only in specified rows or does it only apply to the whole sheet? My example is as follows: I am currently tracking production on 20 units. For the first 5 units I do not care if the duration of a planned task exceeds its target. However for the next 15 units, I do want…
-
Highlight work starting on a weekend
I was planning to use =IF(OR(WEEKDAY([Start]1) = 1, WEEKDAY([Start]1) = 7), "Weekend", "Weekday") to highlight work starting on a weekend.Where 1 is Sunday and 7 is Saturday. And then use Cond Format as suggested by Greg Gates. Says "Unparseable" My Start is Date job starts column and Weekday is column indicating weekday…
-
Locate/Find COUNTIFS
e.g. =COUNTIFS(Recruiter:Recruiter, "Christie", [Deal Date]:[Deal Date], MONTH(@cell) = 10) e.g. = 50 This is an example of how I identify my "deals" for the month in a sheet which lists every deal my company has made. The sheet contains thousands of lines. Is there a way to search/locate/find or highlight these 50 deals?…
-
Alerts for only incomplete tasks
I routinely send auto alerts 3 days before a task is due to serve as a reminder. I recently began sending another alert on the date that a task is due. However, I don't want to send the alert if the task is 100% complete. I guess that I was assuming that the alert wouldn't be sent if the task is complete. Is here a way to…