-
Rounding down based on week ending date?
Hello, I am trying to recreate this formula from Excel into my Smartsheet: =ROUNDDOWN((DATEDIF([@[Leave Date]],[@[Week Ending]], "d") / 7), 0) It is supposed to subtract 7 days from the Week Ending date. How can I make this work in Smartsheet?
-
CUSTOMER ACCOUNT STATEMENTS & TRACKING
Hello folks, I would appreciate some assistance on the following. We run a 'Savings Club' for circa 50 customers. We use excel to track saving credits, purchase debits and running totals using a tab for each customer and a summary sheet to give an overview. See attached snip of a sample statement. I would like to use…
-
Any way to display task names on a Resource View
I want to be able to see a view of all my staff with their associated tasks across all projects. Currently the Resource View does this except it does not label the tasks, it simple shows allocation percentage. Is there any way to get those items that simply list as percentages to show the actual task name? Or is there any…
-
Using multiple filters within one sheet
I am using a sheet as an employee resources database for links, training, graphics, documents, etc. since there are currently 400+ items in this sheet I started creating filters to help employees navigate specifically what they are looking for. Currently the only way I have found to do multiple conditions to a filter was…
-
Link turning red and voiding Hyperlink
Good morning, For our smartsheet we have a hyperlink to a bunch of procedure documents in a column that needs to be clickable on each row. Recently on some of our sheets and some rows what use to automatically hyperlink now turns red and is not clickable. Making it so I have to manually create the hyperlink, which you have…
-
Weakest link formula assistance
Hello! I need to ask for some help. I am trying to set up a Weakest link formula. We would like to use Red, Yellow, Green for Health for each task and have a Weakest link formula at the Activity/Milestone level. * Once a task is complete we will manually use a Symbol column with a Star to indicate completion. * If a task…
-
Contact List Drop Downs
Hi all, We have contact columns that we are trying to add hundreds of contacts too. The number is not above the limit specified by Smartsheet that I found; however, names continuously disappear. For example, User A may be able to drop-down and select John Doe as the main contact, but User B can't even see John Doe as an…
-
Automate RYG ball with criteria criteria pivoting around due date.
trying to figure out automation formula for the status balls based on the following... * Done check box ticked - BLUE * Open Tasks - GREEN * Caution - YELLOW (week before and week after the due date) * Overdue - RED (more than week after the Due date) It's the yellow I am struggling with. Do I need to create an additional…
-
Either/Or Dependencies?
I want to be able to use a dependency like "either/or" instead of "and" ie: Task 3 can start after either Task 1 or Task 2 is finished, but does not require both tasks to be done. Is this possible?
-
Drop-down list
I have a drop-down list of names on my sheet. I need to remove one of the names and add a new name, but I want to keep the list in alphabetical order. I can't find a way to re-order the names in the dialog box where I add the new name. Does this mean I have to go back, delete all, and then re-enter the names, placing the…
