-
SmartSheet Admin
Has anyone developed a job description for a Smartsheet administrator? willing to share?
-
COUNTIFS with multiple contacts in the same cell then reference a second column
Hi, =COUNTIFS([24-7 PM]:[24-7 PM], HAS("Jon Cornwell", @cell), [Project Type]:[Project Type], "LV Switchgear") I am trying to create a summary which shows how many of a certain project type a project manager may be involved in. Hope that makes sense I can get the first part of the formula to work on its own..…
-
Can you index/match partial values
I am working to index match project names based on matching PO values. There are PO values of 4 digits, 7 digits, and more than 7 digits. The PO values greater than 7 digits all begin with 7 digits that are already listed in the working sheet. The reason they exceed 7 digits are for iterations of a PO value. EX:…
-
Formula for counting total of a specific word in a parent column only (not including child)
Hi everyone, Is there a formula to count the total rows of a parent row (instead of making a checkbox section for parent row)? Need help with this the most: Is there a formula I can use in summary sheet that can help me find the total count in a different sheet for a specific word (Ex: "NC", "FCAR", "total of all the…
-
Count If AND
Hi! I am trying to build a formula in which I can count an item from a list as long as it meets 2 criteria: 1- Item submission is in JANUARY 2- A dropdown selection is "No" I truly cannot wrap my head around making the right formula so it gives me the appropriate result as I do not know how to build a count IF formula that…
-
RACI Template???
Hi Everyone, I have been searching Smartsheet, google and this community, but cant find these types of RACI templates. Has anyone had any luck?? It's weird Smartsheet would post articles about these RACI formats, but not actually have them in Smartsheet. Any help would greatly be appreciated as my attempts to create have…
-
How to - Create report filtering on rows containing "Pending Open Update Request"
I have not found a method/solution to generate a report on the leftmost system columns and various statuses such as "Pending Open Update Requests" or has attachments, etc... Suggestions or How-to would be greatly appreciated!
-
I am trying to find the right formula referencing dates and an identifier column
I am working on a formula to check all boxes in the rows that match the identifier column if there is a projected date and it is greater than or equal to today. I collect the start and end date and if a class is delayed or ahead of schedule it collects the projected end date. What I want is if the class is still going on…
-
Simple Payment Tracker?
I'm trying to track payments for several homeowners over a period of time. I already have homeowners in individual rows in other workflows and I copy them to a payment tracker, shown above. I'm not sure how to track their payments in a way that makes sense... I started with each column representing a month, so we can fill…
-
True/False IF formula not working?
I noticed that the formula I was using wasn't working so I moved it to a text column to see if the output is correct. Turns out the output is giving me 0, so no wonder the checkbox isn't checking! My issue is that I'm trying to get a checkbox to check if the values are either -5 or 5. However, I'm stumped on what I'm…
