-
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.
-
Export List of People a Sheet is Shared With?
Is there a way to export a list from a sheet that shows the user's security level? And if so, can this list be imported to a new sheet so that each team member does not have to be added manually to the new one? This is not necessarily for a template that is used repeatedly. It is a group of about 150 people, various…
-
Summary Cell on a sheet that auto-adds form entries to the top row
I have end users submitting forms and the entries are automatically added to the top row. I don't want managers to have to do any sort of parent/child indentation work after forms are submitted, so I've added a column where I have calculated the max value of a very important column and just copied that value all the way…
-
Sum Children() If Date <=today()
I'm trying to create a fomula that will sum the TOTALS column for all the Children() of a parent row that the DATE <=Today(). Any thoughts?
-
WorkSpace Security w/subfolders
When will we be able to add several subfolders to a Workspace, and decide who gets access to each sub -folder instead of always inheriting Will we be able to share folders under sheets in the near future