-
Counting Checked Boxes in one column
Hello, I am trying to count the number of boxes that are checked in the "Missed Information" column and showcase the total in the bottom right corner of the Sheet. I have tried many different formulas: =COUNTIFS([Missed Information:Missed Information], 1) =COUNTIFS([Missed Information : Missed Information], 1)…
-
Need a formula to add/subtract calendar days to a date to create a new date
Smartsheets seems to be defaulting to adding/subtracting business days, but I want the formula to use calendar days instead, how do I do this? My current formula is =[Planned End Date]1 - 195. But I want it to be 195 calendar days, not business days. How do I change it to be calendar days?
-
Need better solution for multiple nested IF statement
Hello, I have a sheet that tracks sprint numbers based on their date ranges. How can I identify the sprint number for a task using the task start date? Right now I'm using this very long formula in the Return sprint number column, and I'm hoping there is a better way to do this. Thank you! =IF(AND([Task Start Date]@row >=…
-
Sum cost in row based on current date
I have a sheet that contains costs for various projects spread out across multiple quarters for 2 years. I'm trying to find a formula that will calculate [Billed to Date] in each row based on the current date. See attached example sheet. Essentially the cells in the [Billed to Date] column will update automatically each…
-
Manual Copy and Paste of rows fails to paste formulas and hierarchy
About 3 weeks ago I began being unable to copy and paste multiple rows between sheets in smartsheet. I have about 12 rows with several columns that match columns in a separate sheet. I am trying to copy rows from one sheet manually using CMD+C and CMD+V (I am on a mac) and paste them into the new sheet. I am able to select…
-
Cross checking grids
Any help is appreciated. Also, if anyone can recommend which training/certification class would be better to deep dive into the formulas and workfflows for these types of specific tasks, I would love the recommendation. I have Registration forms for 2 separate trainings (Training 1 Registration) and (Training 2…
-
How do I remove the text between the second set of parenthesis in a cell?
for example: Tinley Park North (IL) FSU (Tinley Park, IL). Input: Tinley Park North (IL) FSU (Tinley Park, IL) Desired Output: Tinley Park North (IL) FSU I need a formula that can return the desired output but if false then returns the original value of the cell.
-
Formula Help
Hello, I have built the following formula but for some reason the last part of the formula is pulling a blank result, can anyone see what I have done wrong please? If the result is 12 and Internal it pulls blank instead of Creds / prior slides. Everything else works. Thank you. =IF(AND([Total Score]@row >= 35, [Total…
-
Automated Allocation - based on selected attributes
Hello Smartheads! I have a pretty interesting use-case. Columns look like in the screeen below: E Entry Number - values can duplicate Desired outcome: Trigger: Auditor selects her/his user ID in column C Audotor in a row. Outcome: After changing one row, the same user ID will be populated in Auditor column, if ENTRY NUMBER…
-
Formulas in Automations
Is it possible to create an automation that will populate a cell with a formula instead of text or a drop down value? I am trying to get a column to populate with the name of a user who checked a box. For the action block of the automation, I selected Change Cell Value in Column to =([Modified By])@row The automation…
