-
Min/Max Time Formula
I am need to calculate the min and max time for a column. These times are entered manually (from forms) in the HH:MM format because created by and modified by columns are not appropriate for the purpose here. The times are entered into a form. These times are converted in a new column using the following formula:…
-
Formula for adding value to column in one sheet if reference is made
Looking for help with a formula! I have 2 sheets - Production Workforce and Production Totals. We work by job numbers, so would like to have the calculated workforce days from "Production Workforce" appear in the "Production Totals" sheet if a job number reference is made. Any ideas?!
-
Formula with CHAR(10) and multiple references
hello, I am working on a formula to combine all notes from multiple PMO discussion groups. I have it working but in my Master notes column if a discussion group left information blank, the CHAR(10) puts large blank space within the column. Each discussion group is grouped together within the below formula.…
-
Concatenate/Roll Up Text in Children Tasks
I want to rollup all of the updates made in the children tasks into the parent row. Is there a formula that can do that? Here is a screenshot of a parent row with some children tasks. The column with the updates is called 'Updates'. Can anyone help me create an IF statement that accomplishes this?
-
INDEX/MATCH/MAX Formula within a date range
Hello Smartsheet Community! I am helping our team report on an individual who requests the most deliverables within a date range. Meaning, if Ted Williams requests the most deliverables in Q4, Ted Williams should show up in the report based on the countif/helper column. Below is the formula I've been working with based on…
-
Checkbox for Unique Item Name
Hello! I'm trying to create a formula for checking a box for only the first instance of a unique value in the column "ITEM NAME". IE it sees the first instance of "Event Case 1" and checks the box for only that row, and the remaining instances don't get checked. I tried using the AI tool but the formula it creates can't be…
-
HELP!!! Max Collect for Dates
I utilize Smarthsheet to manage a hospital schedule. I need to find out the last time a staff member worked. I have been playing around with Max Collect and constantly failing… #UNPARSEABLE Things to note: The Primary column shows the name of the staffer multiple times with multiple different dates under the Date Worked…
-
Edit Start, End, or Duration from Report
I'd like to be able to edit the Start Date, End Date, or Duration of a task from my report. At present I can only edit Start and Duration from a report because End is treated like a formula. This is problematic when I need to adjust both dates because it forces me or another user to do math (accounting for non-working…
-
Cross Sheet Index, Match, and IF
Hi, Thank you for coming to my help, I really hop this question makes sense. Basically, what I want to do is take the closest date of incomplete tasks and put it into another sheet where I can run automation asking someone to update a report. The reason I want to do it this way is because on the report you could be…
-
Showing multiple dates from the same sheet row in a calendar
I have 6 columns in my Smartsheet that are date columns, two of which are start and end dates. I have got the start and end dates to appear in a calendar report, but the other ones (individual dates, not date ranges) do not show up. I cannot have them as children rows. I have tried applying conditional formatting to the…
