-
Don't include parent rows in checkbox complete roll-up percentage
Hello. I'm new to formulas and need help. I'm trying to figure out how to get the total % complete for a column of check boxes. We need to know the % complete by milestone (which we figured out) AND the total % complete. We use parent rows as headers that should not be included in this total. I had a formula that sort of…
-
Nested SUMIF formulas across multiple sheets
I am trying to create a couple of formulas that don't seem to be working properly. For the first sheet, I am creating a Document that lists Job titles and the hourly rate. Each job title can have multiple hourly rates. We will call this doc "Hourly Jobs Breakdown". (Rates will all be in $00.00 format, I just forgot to…
-
Populating Drop Down list from column of entries in another sheet
I would like to set up a single call log, where I could put information into a sheet that would have a cell with a pull down that would populate with unique client names (or ID's) from a column in another sheet. So, when I put a log entry in, I could have a list of clients to choose from. The next step, would be to post…
-
Link row cells (several at the time) from the resource sheet into a column on the destination sheet
How can I link a group of cells on a row to populate in a column ? Resource sheet Destination sheet (ignore the numbers)
-
Multiple selection on a drop down list
Hi, I read in another tread that the ability to select multiple items in a dropdown list was in development. Does anyone know if that is available now?
-
Issue with Other Sheet References
Is anyone else having issues building multiple other sheet references? It keeps backing out of the formula box when I finalize the reference. It seems to make the reference alright, but I have to type it in instead of the reference going where it should. This has always been somewhat glitchy but it seems a lot worse for me…
-
Why is my COUNTIFS formula counting more items than necessary?
Hi all! I'm currently using the following formula (with references) to count the amount of items that fit a certain criteria (91-180 days, 181-270 days, and >270 days): =COUNTIFS({Age Grouping}, "desired amount of days") The formula works perfectly for the first two criteria, however, when it counts ">270 days", it returns…
-
Dashboard Reports & Row Attachments
Hi! I was wondering if there might be a way to display the "attachments" or "comments" column of a report via the report widget when working on a dashboard? Essentially, I would love to be able to see if/when a row has either a comment or attachment linked to it via the dashboard. It would be even more amazing if that…
-
Formula comparing dates
I am very new to Smartsheet and the making of formula's overall so sorry for this question. I want to create a column where it will be highlighted when the date from column x is 4days or less apart from the date from column y. Does anybody know which formula to use? I started with this: =IF([column x]row number < Many…
-
Multiple forms to a record
Hi, Wanted to check if there is a mechanism wherein smartsheet can store the information collected via different forms at different points in time in a single row ? Providing an example below for more clarity - Lets say we break the client engagement (an enquiry -- lead generation -- service agreement) flow into multiple…