-
Milestone Dates
Hi - I'm trying to figure out a formula that will pull in the next milestone date into a report or sheet. I want to include the project name, the milestone name, and the milestone date. I don't want to see all of the milestones, just the next one that is scheduled.
-
Viewing deleting rows
I've created a sheet that has 165 collaborators. They need to be able to change cell information. Occasionally the notification will say that a certain number of rows have been deleted. I need to be able to view what has been deleted to restore. The size of the sheet is currently 3,000 rows and changes are happening…
-
Status notifications to clients
Hello all, I am a new smartsheet user :) Can you please let me know if their is a way to send a customer the status of an order through smartsheet, i am trying to making it automatic from the order date when it is placed until the order is completed up to keep the customer informed and updated? and i need this to be sent…
-
All videos simple - don't show realty use of training needs
Anyone noticed that all trainging videos are so simple of solutions they really don't help with much beyond the most basic. Like conditional formatting - show me how to deal with wanting multiple columns to change format based on one criteria - not a whole row. How do you do that? How many formats do you really need to…
-
Creating a cell link to a different sheet with different working days
Dear community, I have created a sheet for Data Center migration planning. By definition these activities are planned during normal working days (Mon-Fri) but the migrations happen during weekends, as it requires to stop servers and so that's the lowest impact to services. This sheet has defined all days as working days to…
-
Date column changing the default behavior of a column
I have a date column called Date of Resolution . I also have a column next to it called Resolved? which is a drop down of either YES or NO. What I want is the Resolved column to automatically fill in from the behavior of the Date of Resolution column. If the Date of Resolution cell is filled in, then Resolved changes to…
-
Strategy category options?
How do I add to the strategy category options or edit them?
-
Web Form not refreshing into worksheet
I created a worksheet to track requirements. I then created a Webform to gather this data from end users. I ran a test entry. I received email with URL to webform. I entered the data and submitted. I received a confirmation message and email. A notice appeared on the worksheet that an entry was made. I click refresh and…
-
Formula help!!
Please view the screenshot I have provided below. I am attempting to create a formula here that takes the whole assigned to row and the end date row. I want it to show the number of times it shows a certain name, in this case Dean, and if that task is one week past the current date. I would also like two weeks and three…
-
Advanced Notifications options - add scheduled notifications.
I like the improved Notifications functionality and would like to add one more suggestion. Can you add a "Delivery" capability so that the frequency/Date/Time for the notification can be customized? This is similar to the existing functionality in SmartSheet Update Requests.
