-
Help With Formulas
I am attempting to automate the RYG column shown in the screen shot below. I need the formula to look at the finish date and status columns if the status is not "Done". I need some feedback on the formula that I am using below. =IF([Finish]1 < TODAY(), "Red", IF([Finish]1 = TODAY(), "Yellow", IF([Finish]1 > TODAY(),…
-
Reminder when items assigned to user
Hi All, This is probably something easy to do, but I'm still a little new to SS administration. I have a issues log that has a "Assigned To" Column (using contact list) and a "Modified Date" (system). I am trying to find a way to send the "assigned to" user a reminder email anytime something has been modified and the…
-
Filtering for a Particular Value When Multiple Exist
I am using a text type column to populate multiple values that I would like to be able to filter on. However, the values have letters and/or numbers that because of schema show up in the Filter output that are not desired. MS Project uses commas (and some other values that you define) as separators. Does Smartsheet use…
-
Totals by month
Hello, I'm trying to figure out how to get totals by specific month. There are 3 columns I'm trying to pull data from, a monetary column called "Unit Price," a dropdown list column called "Produced," with options that read "1. In Production" and "2. Produced," and a date column. Basically, I want to have a cell that shows…
-
Allocations
Scenario 1 I have a task that happens every Tuesday but only takes 1hr of my time. I don’t want to create multiple rows to indicate this as one 1hr of the day, is there another way to do this? Scenario 2 I have task that happens with a span of 5 days but only takes 3 hrs how do i calculate that? Is there a way to do this?
-
Formula - Date Column
I would like to add a second date column in my sheet where the Start Date is manually populated and the new Date Column would count backwards 15 working days and automatically populate. Is this possible? Thank You, Roger
-
Nested Formulas issue
Hello all, I am currently working on moving some trackers into sheets from excel and I have hit a roadblock with the following formula which works in excel. I have looked at the template formula sheet and I can get them individually to work however not together. Thank you in advance for any help. =IF(J6>0,"Task…
-
AVG() returning divide by zero
Hello, I am trying I receive help with making a formula that will take the average of the children rows. I found a VERY similar post, and tried to use that formula, but it did not work. The problem is that I have tried to take the average of the children rows, and display it in the Parent roll. The average is of…
-
Can I add a formula to a drop down list cell?
I currently have drop down list that contains, "Not Started", "In Progress", and "Complete". What I would like to do is add a formula that automatically changes the drop down list from "Not Started" to "In Progress" if the Duration cell has been changed from 0% to anything non-zero. Is it possible to add a formula to a…
-
Formulas
I have a drop down text for my second column, I would like to insert a formula that when shipped is selected from the drop down, that it auto checks the check box in column 4 for complete. I have looked through all formula help sheets and can't seem to find this one. Is this even possible? If no, does anyone have any ideas?
