-
Calculating Time in HH:MM:SS
Hello, I'm hoping someone might be able to help me with calculating time in Smartsheet. We work with production teams in broadcasting, as well as other non-production teams, so calculating time is becoming rather vital, as more and more departments are using Smartsheet for a varying number of use cases: people and resource…
-
COUNTIF by MONTH in Sheet Summary Field
Hello, I'm trying to count the number of entries created in a month, based on the timestamp from the system generated Created field. I am able to do this with a helper column, where I perform the Month() function from the Created field in a column and then use the Countif formula in the Sheet Summary field (ex: To…
-
ISCONTACT function
Looking for the ability to create a nested if statement that evaluates certain criteria, however, because some of the criteria is a contact, there isn't currently a way to define a contact in Smartsheet apart from text. It would be great if we had a function that evaluates a cell as a contact.
-
Document Builder Customization
Hello, I am trying to use the Doc builder to populate a plant tag. This is thin and tall and we are tying to fit all the info onto it. Main question: Can I program the doc builder to turn text sideways so it can fit on the plant tag. See screenshot below I want the WHITE RNTZ to be turned to the side.
-
INDEX, MATCH, IF Formula
I am trying to pull a value from another sheet if the cell matches another cell and IF it is not checked off in the other sheet: If the ABV on sheet 1 matches the course in sheet 2, I'd like to pull the "EPM" from sheet 2 into sheet 1, but ONLY if the "Archived" column on sheet 2 is not checked.... (I want EPM on sheet 1…
-
Formula Help - Open, Pending, At-Risk and Complete
Hello, I am looking to create a formula if a request is/was submitted I would like it to display open, pending, at-risk, or complete. I also need to exclude changes to that request if the status reflects canceled, rescheduled, no-show, or declined. Currently, I have a vlookup to display only the open or completed requests.…
-
Need a COUNTIF of "% Complete" cells that are either blank or less than 100%
I just can't figure this one out. Any help is appreciated.
-
Restrict duplicates in a dropdown single select column
Hello all! Does anybody know if SS has a way to restrict duplicates in a dropdown single select column? For example, "Project 4" is already using "D," so when I select a value for "Project 5," "D" would not be available since it's already in use. Or, if I select "D" for "Project 5" it would automatically change "Project 4"…
-
Fields Will NOT Add to Form After Completing Formula
I recently had a Pro Help desk call to figure out how to add a pre-populated field to a form. We got it working easily and I will paste the formula below (we added the Work Order ID field to the form because it tends to be filled out incorrectly). =FormLink?Work%20Order%20ID=" + [Work Order ID]@row I tried to write this…
-
AVERAGEIFS
I've looked through the community and think AVG(COLLECT) is the answer to needing two variables to match before averaging. I'm also referencing another sheet, which isn't an obstacle for me any more. I have a formula that works but need to add a 2nd variable. What I want to do is create a "calculator" that an office leader…
