-
Bridge vs. Zapier vs. UiPath vs. ???
I'd love to hear feedback and use cases for anyone using Bridge, UiPath, Zapier, or another external system in tandem with Smartsheet (yes, I know Bridge is a Smartsheet product). I've used Zapier in the past, but only for simple tasks. The company I recently joined is using a lot of Power Automate and Flows and it feels…
-
Help with VLOOKUP
I am trying to pull data from one sheet into a summary sheet. Basically I am looking to pull if a given site met a target on a given day -- an admin is entering in the number of employees reporting for work on a day for each of 12 sites into a Smartsheet (called KU MR Attendance), and I need to see if they are meeting the…
-
I'm Trying to flag if a colum says RISK but it comes up as #UMPARSEABLE
Help please =if(Status@row=RISK, 1,0) Is not working
-
Check a Box, Reference Another Sheet, Days from today
Hello, I am working with 2 sheets. 1 sheet is providing a summary of the other sheet. I need assistance with creating the formula. On the summary sheet, I want to check a box if there is a row listed on the other sheet with the same city and has a scheduled date of 6 months from today. Formula: =IF({Site}, =Site@row,…
-
Looking for help with "Contains"
I am looking for some help with the Contains function. I currently have the following formula which is working fine. =COUNTIFS({2021 Archive Range - RFI Reason}, "Census", {2021 Archive Range Assigned To}, "JP Pedicino") I need to update it to search for CONTAINS "Census" in the 2021 Archive Range - RFI Reason range and…
-
Setting "Date Completed" column date based on status change
Hi! I'm trying to set up a formula for my Date Completed column that pre-populates the date in that field to the date where the Status on the same line = "Complete". Right now I'm using this formula: =IF(OR(Status125 = "Complete"), TODAY(), "") One problem is that it doesn't add the formula for newly added line items. Also…
-
vlookup error
I am trying to write my first vlookup formula in Smartsheet and running into an error I can't resolve. This is the sheet that I am writing the formula in: This is the formula I've written: And this is the lookup_table am referencing: The Detail Status that is my search_value is in the first column of my lookup_table. My…
-
Formula help: Same criteria, same date, multiple rows
I feel like I'm missing something obvious here, but I'm struggling to come up with the correct formula to accomplish a task. Multiple attempts have come up empty. What I'd like to do is: When there are more than one instance of the Distribution column displaying 4 stars on the same day, I'd like the checkbox in the Status…
-
COUNTIFS Fomula
I created a COUNTIFS formula in Excel which would count the values "Expired" and "Overdue" and add the total's together. Excel Formula: =SUM((COUNTIFS(C:C, "CO-CURRIC-COI",J:J,"Expired")),(COUNTIFS(C:C, "CO-CURRIC-COI",J:J,"Overdue"))) When trying to emulate it in Smartsheet, I get a #unparseable error. Not sure what I am…
-
Duration column formula: two situations
Hello, I have three date columns involved in the duration: Date Submitted Date Completed For Future Requests My current duration formula only uses the Date Submitted and Date Completed columns: =IF(Status@row <> "Complete", NETWORKDAYS([Date Submitted]@row, TODAY()), NETWORKDAYS([Date Submitted]@row, [Date Completed]@row))…