-
Iterative For loop? SUMIFS?
Hi all, I am a little stuck on capturing data without adding additional columns/helper sheet. I need to compare the 2 entries of inventory audit in the same column one by one. To do that I can think of using an iterative For loop. With the example attached below: Is it possible to iterate each row, [audit#]1 - [audit#]2...…
-
Select Column Range
I have a form where there are 120 columns and collaborators enter the information through their department dynamic views. For easy math, let's assume each department has 20 columns to fill out. The last column is a checkbox such that if all 120 columns are filled out (essentially not blank), this check box will be marked.…
-
Get the first column from a table.
I have a table reference: {Checkbox Table} I would like to get the percentage of all the checked boxes, but by column. Ex) What % of boxes are checked in column 1? Column 2? etc. How can I modify this formula: =COUNTIF({Checkbox Table}, =1) / COUNT({Checkbox Table}) to allow me to do that? I have a lot of columns in this…
-
Calculating Time
I am trying to calculate the hours and minutes between a start and and end time. Firstly, what column type should the start and end time columns be, secondly, how should the time be written and thirdly, what formula would I use to calculate the difference between the two columns.
-
How do I write a formula/function that uses whichever scenario is earliest?
I have a sheet with two optional dates. Something happens 45 days from the date something was received or Something happens 145 days from the date of an incident Example. An incident occurs, and materials must be submitted. We then have to write a report within 45 days of the date the materials were submitted or within 45…
-
Latest Comment Limitation?
Does the latest comment of a line only show up in the latest comment column if you use the @specific person? If I just type a comment without and @ it does not show up in the column. I was just wondering if that is the way it is supposed to work, or if something is broken for me. Jay
-
Formula help!
Hello! I need help with a formula. I need to be able to have an "IF" formula with an "AND" and an "OR" included to reference two different columns. Below is what I currently have, and while it works, I haven't been able to add in an "OR" statement to account for another column that needs to be referenced. Any suggestions…
-
Monthly Automation report sends out last months data
I have a simple automation that looks at an employee sheet. On the 1st day of each month at 10am Central a report is sent to my email that SHOULD show the current months work anniversaries. However, every month I receive the email on the first of the month and it shows the PRIOR month anniversaries. Within the sheet I am…
-
Last Month Formula?
I'm trying to develop a formula for a column that lets me know if the Event date in that row is "Last Month" or not. A simple 1 or 0 result for yes or no will work. I had put together what I thought would work using Date, Year and Month, but when we hit 2023, it failed. Looking for advice.
-
Is It Possible / Formula Request
Hi, I have a Smartsheet that has IOKR's in it (initiative, object, key result) that is not using parent / child rows. Is it possible to create a formula that gives me the health of initiatives based upon the health of the objectives which is based on the health of the key results? One initiative may have multiple…
