-
How to Alter the "Sheet - IT Ticket Metrics"
I want to alter this sheet, found in the IT ticket Template, to just show the metrics for a specific customer. the original formula looks like this: =COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1) and my attempt to specify to a single customer looks like this =COUNTIFS({Created Date Range},…
-
Emergency Preparedness with Smartsheet
Hello SS Community! Does anyone of examples of a Corporate Emergency Preparedness Checklist that one can share with me as a starting point? Tips greatly appreciated!! Thank you!
-
Webform not updating after sheet changes
Hello I have created a simple sheet with data for internal materials requests, including an approval loop via workflows. I then created a webform to gather input; in order to test it, in the approver / exectutor user fields I used fake data (=always myself and my colleague) to test it. It works. I have now updated the user…
-
Can an email template be built in Smart Sheets that is sent out to a DL?
Can an email template be built in Smartsheet that can accept free form text in certain fields and also be able to be emailed out in the G-Suite to a DL. The other condition would be to be able to reuse the sent email message and be able to send subsequent email updates using the same email thread in the G-suite. Not sure…
-
VLOOKUP on the if false of another VLOOKUP
I have a worksheet that I want to reference 5 reference sheets that contain staff members. Because of the large scale of staff members. We split them up by region. I want to create a column formula that will look up a "District ID" and return the "User" If they exist in one of the 5 reference sheets. This is my current…
-
SUMIF with cross sheet referencing
Hello all, I created a sumif formula that would reference another sheet. Copied below is my formula but it always results as "incorrect argument". I believe the problem is in the sum range (bolded in formula). Can someone please assist? Thank you, =SUMIF({SIS Quarter 1 Range 1}, [Column15]48, {SIS Quarter 1 Range 2})
-
Automated import through the API
Dear Smartsheet-Community, I am doing a semesterthesis in coorporation with a company that has been using Smartsheet for a while. My job is to create an automated order tool for AM parts, which serves as an order backlog including the 3D models and part properties and that enables communication with the supplier. Object of…
-
Using CountIfs to track a column will multiple options
Hi everyone I have a multi select column that I am trying to use a countifs statement to count of instances of a name. However it only returns cells where only the name exist and nothing else. Does anyone know how to make it that it counts all instances? Formula below for example =COUNTIFS({Training Project Task List Range…
-
Formula for RYG status based on Drop down column marked: Complete, In Progress & Not Started
Hi there! I am looking for help creating an IF formula to produce the RYG based on another column that has a dropdown (Complete, In Progress & Not Started). This is what I had: =IF(Status@row = "Completed", "Green", IF(AND(Status@row = "In Progress", "Yellow", IF(AND(Status@row = "Not Started"), "Red"))))
