-
I need help using multiple functions, if statements and parent/child.
I have 3 columns that have information; Scene, Take and Revision. The scene can be broken into sub-scene and sub-sub-scene etc... This column will always have a value. Columns Take and Revision may or may not have a value. I would like to add a fourth row called Full Name. This column will combine the information. I was…
-
Exclusion Formula for Sum/Count
I am trying to get a total of my "Forecasted Amount" column which should include the following stages "0-Lead"+"2 - Qualified"+"3 - Proposal"+ "4 - Final (EL)"+"5 - Win". Currenly I have it set up to only not include the "6 - Lost" with this formula: =SUMIFS(CHILDREN([Forecasted Amount]52), CHILDREN([Referral…
-
Reference a column in another sheet
Hello - My company is new to smartsheets but it has ALREADY made a huge difference for us. I'm playing with functions that reference other sheets and I have a very specific question - I'd like to sum all of a column IF two conditions are met: the dates match and the payment type is the same. The formula I'm working looks…
-
How to show cell hierarchy values
Is there a way to show the values of cell hierarchy no matter the amount of parent/child? In this example (see screenshot) I would like to output: 121b1a Thanks
-
#UNPARSEABLE
I cannot get this formula to work. Any suggestions? =IF([% Complete]1=0%,"Not Started",IF([% Complete]1=100%,"Completed","In Progress"))
-
Formula to determine the date that another cell was updated
Hello, Looking for some formula help. I am using the formula below and need to figure out how to display the date the Status cell was changed instead of updating to today's date. =IF([Status]1 = "Completed", TODAY()) Thanks for your help! Andrea
-
Automatic Cell Highlighting
I am logging man hours for construction jobs. I have three columns that perform this function. One column for "Budgeted Hours", one for "Actual Hours" and one for "Remaining Hours". I input hours into the "Actual Hours" column daily and it updates the "Remaining Hours" column automatically. I want to set up a formula that…
-
Sum of work log between a date range for given list of users
Hello, I really need some help on this. I have two sheets one with user work log information with dates and user name. Now I want to add the efforts for a given date range and for a particular/all users. I tried summits but not able to come up with anything as it is always giving mw wither 0 or invalid argument. I tried…
-
HELP:Automate Status for Range of Dates
I am trying to construct a formula that will make the status turn yellow when TODAY() is 4 days to and 4 days after the date in the [Due Date] column. I was hoping the following would work but it does not: =IF([Due Date]8 <> TODAY(4), "Yellow") Any ideas on how to write an if formula to cover the date range?
-
Capturing multiple statuses, reminders for recurring tasks, form
Hello SmartSheet community, perhaps someone can give me ideas on how best to set up the following: I have 30 customers and 30 different reps (one for each customer) who need to provide a status on that customer on a regular basis, at least once every two weeks. The requirements: * Use a simple form to collect the data,…
