-
How can I move columns from a row to individual tasks/ rows in a different sheet?
I am trying to conduct a survey at 100+ locations and use the survey results to generate a "custom" action plan for each site based on the responses. Once the action plan/ task list has been created I will need to track the project status of the task completion. The logic for the action plans is easy to address. I'm having…
-
Multiple Columns with possible answers using sumif(s)
I'm really not sure which formula or combination of formulas i should be using. I need this to be embedded because i'm already curating over 50 columns in this sheet i just can't see managing much more. Column 1, 3, 5, 7 have drop down choices A, B, C, D Column 2, 4, 6, 8 have free text for numbers I have total columns for…
-
Round Up to nearest 100 - Solution Found
I couldn't find my solution w/in these discussions, so I wanted to share my findings to help anyone that may need it. I have a sum formula that can equal any number, but i need the final total to be to the closest 500. 6259 = 6500 825 = 1000 I tried to embed my roundup formula with little success and the help line…
-
Smartsheet SUMIF
Hello Smartsheet Community, I just want to have a Sum of the values based on the day range and week number range in the smartsheet, i tried with SUMIF in smartsheet it was not possible. here i am posting an example for your understanding, which i have done in excel. I have a german pc, so SUMIF is showing as SUMWENN in the…
-
Using countifs for multiple criteria
I have used the following which results in 'unparseable'. What's wrong with the formula please? =COUNTIFS({P&P report - AH - 15 Jun 22 Range 1},[Primary Column]@row), COUNTIFS({P&P report - AH - 15 Jun 22 Range 5}, "1"))
-
If this date, than that date formula
I am seeking a formula that takes a date from one column and populates a weekday date in another cell 45 days later, or 90, or....however many I indicate. Ideally, the said "then" date will be a day during the weekday, if possible, but it's not a deal-breaker.
-
How to concatenate multiple IF statements' texts
Hello! I'm new to Smartsheet. I have a sheet that used to be in an Excel file. There's a column call "Currently Delay (Rolled Up Reasons)" which I'm having trouble creating. The original Excel formula is: =IF(AU6="Yes", CONCATENATE( IF(AND(AE6<>"", AF6 > TODAY()), $AE$3 & " ","") , IF(AND(AG6<>"", AH6 > TODAY()) ,$AG$3 & "…
-
How to "Roll up" hierarchical data in indented cells in a gantt chart
Greeting, Smartsheet newby here so be gentle. I'm trying to build a "quoting tool" for our business based on a smartsheet gantt chart. Ideally I'd like to be able to enter the hours that will be worked by each of our departments and have Smartsheet calculate a proposed budget. This works pretty well with our existing…
-
How can I convert multiple row items to individual tasks?
I am looking to create a survey and "custom" action plan response for 90+ different sites. Each site would complete a simple questionnaire through a Smartsheet form. Based on the answers each site would then get an action plan based on how the question were answered. Once the individual tasks/ action plans have been…
-
Checkbox formula for current month and the three next months
Hey everyone I am hoping you can assist me. I am trying to create a formula that will check a box for the current month and the next three months. The formula we have tried is: =IF(AND(MONTH(Month@row) = MONTH(TODAY())+3, YEAR(Month@row) = YEAR(TODAY())), 1, 0) I have placed a snip below. I know we are in June, so July,…
