-
Changing date within formula
I am looking to find a way to incorporate a changing value to the hours needed per day in order to meet deadlines. In addition i've input task completion % in order to account for the completion rate. My current formula is the following : =IF(ISNUMBER([Man Hours Allowed]3), ([Man Hours Allowed]3 / Duration3) * (1 - [%…
-
Nested If Statement with If/And in it
I'm having trouble adding If/And to a nested IF statement. Hoping someone might be able to spot where I'm going wrong. What I'm trying to do is automate a red, yellow, green, blue column. The last criteria combine criteria in two separate fields. Thank you! =IF([Approval Status]1 = "Denied", "Red", IF([Approval Status]1 =…
-
Adding Month and Days to a Cell
Hello everyone, I have a Completion Date of 1/08/2019 and I need the next cell to be 1/29/2019 (which is ten days before 2/8/2019) and the third cell to be 2/18/2019 (which is ten days after 2/8/2019). I've tried every which way I could think of to get this to work. Any ideas? THANK YOU!
-
SUM or COUNTIF across sheets
I have a Smartsheet for each fiscal year, and will continue to add new sheets for each FY. On a separate sheet, I want to find the sum of values that appears in all of the FY sheets. For example, if I want to sum the total amount an employee makes on my Summary Sheet, referencing data on multiple FY sheets, I know I can…
-
How do Link a Column w/ drop down items between separate forms/sheets?
I'm new to SS. This is my first project. I have an audit process I am building for a customer. There are 5 separate forms needed for the audit process. I originally had all 5 forms feeding the same sheet but with over 100+ columns for each audit, I went crazy scrolling left to right looking for the information I needed and…
-
Sumif across Children and Grand Children
Dear Community, I am trying to SUMIF accross all Children and Grand Children but unfortunately retrieving an #UNPARSEABLE value. Here are the formulas I have been trying: SUMIF($[Payment Status]5:$[Payment Status]50), "Received", [2019 Wk 02]5:[2019 Wk 02]50)) => result to #UNPARSEABLE SUMIF(CHILDREN($[Payment Status]27),…
-
Circular Reference Won't Go Away
Hi, I'm working on fairly large sheets that reference many other sheets. My main summary sheet is doing SUMIFS formulas to summarize and sum to a higher level. The summary sheet column is showing a Circular Reference error. I found the error on my raw sheet and corrected. However the main summary file still shows a…
-
Create a list based on set of values
Hi there, If, for example, I had a stock list telling me how many of certain T-Shirt sizes I have left vs how many have been ordered. How could I use that to return the sizes, in text form, of those which I don't have enough of. See attached image for example. In this example, I would want to automatically generate a list…
-
Auto updating a status
Hi, I am looking for some help with a formula please? I have a scheduled date which is static, Column name "1st Scheduled" i then have a completed date, Column name "Completed date" I am trying to have the status column update to "Overdue" if no date is entered in the "Completed date" and today is past the "1st Scheduled"…
-
IF Statement Help
Hello, everyone - I'd really appreciate some help writing a conditional formula for a field entitled "Aging Type". There are 4 valid values for the field - Waiting on Approval Waiting on RFx Waiting on PO Waiting on Payment Waiting on COP The values are based on seven columns - ECM/IM Approved RFx # RFx Sub'd PO # COP…
