-
COUNT CELLS BY MONTH WITHIN ONE RANGE (COUNTIFS?)
Hello Everyone! First time asking for help, I always found my answers within everyone else's questions, but not this time! We work off one main sheet where all our leads come in, I would like to create in another sheet a count by month of that "created date" column, to see how many leads came in in January, in February,…
-
Time in a Sheet across Three Shifts - Best Approach?
We run three shifts over 24 hours - some tasks may start on one shift and finish on another. Is there a best practice way to set this up in SmartSheets? I have searched the community and found limited information on this - if it's already been addressed, please point me to that information. Thank you
-
Creating an end date in a row...
I have created a Smartsheet with columns and would like to have column data automatically created in another column. I have unsure how or if I can make this happpen. One column is titled "Start Date" and we have a date entered. Another column is titled "Timeframe" and has a drop down box with selections "3 days, 5 days, 15…
-
Index(Collect error
This discussion was created from comments split from: Formula for returning value based on whether a date is between two dates.
-
Automatic Form copy
Hi is there anyway to automate that a copy of the form is submitted to the author rather than them ticking the box?
-
Copy cell on form submission
I need the field to be a dropdown in the form (currently set as one column "options") and a second column "updates" that is a text type to sync with JIRA. On form submit, I'd like to copy the value selected in "options" column (opt 1, opt 2, opt 3) into the second column "updates". The updates column may have other copy…
-
How to stop cell link?
I want to stop the cell link so that when i use the formula it won't change the value of other columns? Can someone please help?
-
Need help with If/then status formulas
Hello! I am trying to create a formula to show the status symbols for the projects I'm working on. The following formula keeps giving me an error and I am stumped. =IF([Course 1 Due Date]@row), < TODAY(7), "Red" , IF([Course 1 Due Date]@row), < TODAY(14), "Yellow", IF([Course 1 Due Date]@row, < TODAY(30), "Blue"))) I am…
-
JOIN COLLECT for Checkboxes
Hello All, Is there a way to collect information using a JOIN COLLECT formula? Column 2 is Name Column 3 thru 5 ASL. Columns 6 thru 8 is are the names I want to populate based on the checkboxes (ASL). Column 3 can have two checkboxes versus 1. Ultimately I would like all checkboxes that are checked to populate names in…
-
Need to build a formula that grows each month
Good Afternoon All, I have a formula that has to build for each month I already have the formula for January and it works IF({January A Sum} <> 0, {January A Sum}, {January F Sum}) The February formula is bigger IF Jan A Sum and Feb A sum <> 0, it would equal Jan A Sum + Feb A sum If Jan A sum <> 0 and Feb A sum = 0, Jan A…