-
Total of Certain Value Across Multiple Sheets
Hello! Hoping someone here can help. I have 6 sheets that are identical in setup and parent rows (inventory for each vendor - Child rows are only varience being actual inventory). I'm needing a summary sheet that totals the quantity across each of the 6 vendor sheets. I've tried a variety of…
-
1 PDF that requires two signatures, not sure where to start, kindly help?
Hi all! I'm looking for some very basic help to get started as I'm not sure where to. I have a single PDF form that requires two signatures. The first signature should be from an employee, say "x". The second signature then needs to be of that employee's supervisor, say "y". Once both folks sign, that form needs to go to…
-
Automated Drop down or Formula?
Hi all, I was wondering if there is a formula or drop down function that can auto populate words or drop downs? As seen in my conditional formatting for "Days Left Till Expiration it conveys whether if it is red, Yellow, Or Green based on the amount of days passed or upcoming till a Term end date. I'm wondering if I can…
-
Days left on a Term End Date
Hi all, I was wondering if there is a function that conveys how many days are left for renewal license as seen in the image. Obviously the dates listed have been expired & I was wondering if a negative positive function can be conveyed as an example -1,847 in the "Days Left Till Expiration" column
-
How do you exclude a specific dropdown status from another sheet in a formula?
I have 2 sheets. One sheet (Requestors) is tied to a form for people to get information about a possible coach. Through this awesome community, I've been able to figure out how to pull the information I need from the 2nd sheet (Coaches list), and display it in an automated email to the requestor (with a line break between…
-
Upvote Function / Brainstorming Layout
Does anyone have a template or is there a video that shows how to create a sheet that has an "upvote" or "voting" function of any type? Ideally what I'm looking for is a way to have different product ideas listed out and then allow for our team to vote on which items they like the most.
-
New user here... Need formula on how to count how many entries in a column are in a specific month
Hey there, I have wracked my brain for hours trying to find a formula that will allow me to count how many cells contain the month Jan, Feb, etc. So far I have tried the following.. Please let me know how I should adjust: =COUNTIFS({[ Range 1]}, @cell >= DATE(2024, 1, 1), {Certificate of Destruction Range 1}), @cell…
-
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:…
