Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2015 Posts
Archives for December 2015
Discussion List
Conditional formatting based on date column entry being past another date column entry.
I have Finsh date clearly and have put another column for Actual finish. If the Actual date is before or after the original Finish date I would like to be able to format it. Is there a way to do this?
Status Symbols
Can you formulate status symbols to change based on % numbers in another cell?
Change first day of week to MONDAY, instead of SUNDAY
in the German speaking part of Europe, a calendar is usually shown with MONDAY being the first day, and both Weekend days SAT and SUN at the end of the calendar. This should be something that is user specific. So where in the user setting can either the admin or the user himself change the first day of the week from SUN to…
Dependent Picklist in a Web Form
Is there way to have a dependent picklist in a webform?
Formula to automatically check the checkbox in a "complete" column
I'm using RYGG balls to indicate the status of a row. Grey represents complete as a colour. When a cell is changed to grey in the status column, I'd like for the checkbox in the "complete" column to automatically be checked. What formula would I create to complete this task?
Marcos to run hide / unhide on a preset group of columns
Requesting the ability to have macros that would apply hide / unhide to a preset group of columns. I encourage my clients to put all contacts on one sheet rather than one sheet for customers, another for vendors, a third for who knows what. Each of these types of contacts has a few unique columns which are not used for the…
Question regarding lag times
I am using predecessors in my spreadsheet and need some assistance with lag times. For example, one task is to sign the contract with the meeting planners (we do that in November)--that's line 12 in my sheet. Our first payment is not due to the planners until June of the following year. If I put line 12 in as the…
Calendar view that displays the allocated resource
I have several project spread sheets with resources allocation. I built a report that brings the spread sheets together to display the tasks assigned to the various days. I would like this same calendar data to dislpay a calendar view of the resources allocated to the various days. The questions is how? The calendar view…
How can I create column which could by readable by defined users
Hello, I need to create a collumn which contains secure information. This information /salary/ is only for some users /group/ readable. Is it posible to create collumn with restricted access?
How do I create a formula to SUM the Child column only if a tickbox in a separate column is ticked
Hi I need help with creating a formula to calculate the numerical values in the child coulmn but only if a tickbox is ticked. So far i have come up with ="Total Withdrawn: £" + SUMIF(CHILDREN(Completed2:Completed4)) Any help would be appreciated. Jordan