-
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…
-
Formula in Resource % Allocation column
I have added a column to put in the number of hours I would expect the task to take each day. I prefer this to having to work in percentages of a day and think this will be easier to request of my team. To allow this I need to put a formula in Resource % Allocation column to divide the number of hours by the number of…
-
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…
-
Formula Writing-COUNTIFS & SUMIFS
Hello, I am trying to get a couple formulas to work to filter down a roll up sheet. I have tried the following formulas to no avail: =COUNTIFS(Phase 3:47, = "Leads", [ Phase 3:47, = "Closed"], [Phase 3: 47, = "In-Service"], [Phase 3:47, = "Closed"]) =SUMIFS(Total Project Cost(), Phase()="Leads") Let me know if there is…