-
Date from Week Number
Is it possible to get a date (mm/dd/yy) from a week number? Ultimately I'd like to get the Friday of the week number. Using today as an example (1/11/18), the week number is 2 and Friday is 1/12/18. I've tried some different Excel formulas but am not getting anything to work in Smartsheet. Thanks!
-
Count if formulas
Hello, I have a fairly simple formula that I need assistance with. I have a 'Date completed' column (UK Date format) and a check box column, 'Test1'. I want to do a count in a separate cell for all the rows that have check boxes ticked for within specified month period. E.g. Count the number of test completed in May. I…
-
Will SUMIFS work with a date and a checkbox?
I am trying a SUMIFS formula without much success. The formula needs to return the Distance if Completed Date is before 31/03/20 and Signs has been ticked/checked. Distance (number) Completed date (date) Signs (checkbox) Is this possible? Thanks Faz
-
How do I reference different columns from another sheet in different formulas?
I am creating a sheet with formulas that include ranges in another sheet. The ranges are defined by column. It seems I can reference only one column across all formulas in my sheet. Whenever I go to change the range in one formula, it automatically plugs that same range into the other formulas. How do I create multiple…
-
IDEA: Create Cross-sheet references from reports
Just want to throw this out there. I am referencing three rather large sheets and trying to bring in some COUNTIF data but keep getting told that I am referencing too many cells. This is prohibiting me from creating the data I need. It would be great if you could do cross-sheet references from reports. This would allow me…
-
Summing VLOOKUP results
Hey community, I'm creating a way to judge submissions, where each judge has their own smartsheet (so they can see/edit their own markings but not be influenced by others). I need to be able to know (1) how many times a submission was judged, and (2) what the total score is on one single sheet. * Currently I've drafted the…
-
Auto generating mmm-yy cell
Hello, We have set up a cashflow sheet that gets graphed within a Project Dashboard. The example attached suggests that the Project commences in January 2019. Ideally, a user could enter the commencement month mmm-yy in Column 4 (Green Cell) and the adjacent cells automatically increase incrementally by one month across…
-
COUNTIFS problems
I am doing a metrics sheet to give department heads better visibility on our workflow. One of the metrics I need is how many items have been shipped, but not yet invoiced, I have a date shipped culumn (date) and an invoiced check box (boolean). Several other formulas have similar setup criteria and are also not working.…
-
Drag Down Predecessor Formula to change with rows?
Hello, So I have created predecessor formulas but when I drag them down or copy and paste them to another set of rows down below they still refer to the first rows while I want them to refer to the new rows but in the same order. For example, If on row 6 I have the formula 5FF+6D, I want to be able to copy and paste it to…
-
ISBLANK Nesting
Good Morning All, I am new to Smartsheets and would like some assistance on what I thought would be straight forward and I know I am missing something basic. So the formula in English: Is DATE 2 Blank YES - then NETDAYS between DATE 1 and TODAY in DAYS NO - the NETDAYS between DATE 1 and DATE 2 in DAYS So I thought it…