Can't get my formula to work.
The Formula below works in excel, but because ROW isn't a formula in Smartsheet, I can't figure out how to get it to work. Can anyone help me out here? =IF(ROW()=1,B$1,(IF(B4="May Require Attention",1,(IF(B4="Requires Immediate Attention",2,"")))))
Countifs drop-down multi columns
Hi, I'm unable to get countifs results on this sheet where GEO is drop-down list column allowing for multi values and STATUS is a drop-down list allowing single values. I'm looking to count the number of values GEO if the STATUS is COMPLETE. In this case: EU, COMPLETE (2) US, COMPLETE (1) AFR, COMPLETE (1) Any idea how to…
Hi All, I need a formula to identify keywords in a paragraph and assign the paragraph to a specific person. The goal is to determine a keyword in a given paragraph and then associate it with a designated individual this formula works in excel. =IF(ISNUMBER(SEARCH("scaffolding", A1)), "Summit",…
COUNTIF, CHECKBOX with CONTAINS BRANCH "MIL"
Hello, Please help and thanks in advance. I am trying to Count all the Key-User cells with a checkbox where the branch is MIL. I have tried the below formula but keep getting #UNPARSEABLE. Formula I tried is =COUNTIF([Key-User]:[Key-User], =1), CONTAINS ("MIL",@cell,[Branch;Branch]) Also tried…
I am curious if an update request from can be sent out via text message? We are using the update requests for mileage and hours on our trucks and welding machines. Right now I have it to automate when dates are reached and then an email sent out for the pertinent information. Just thinking a text could be super slick…
Can I do a cell link with an absolute?
How can I cell link but have the information stay in the exact cell I pull from when the data gets upadated? For ex the bottom sheet is the information i want to pull from. Column RDC, row 1 is the value I want in that cell to return to the top sheet every time the bottom sheet gets updated no mater the information in that…
Hello, I have a formula that calculates the current month's total of an item. I need a new one that will filter by a specific month/year when edited to do so. How do I update this to do that? =SUMIFS(Spent:Spent, [Areas of Project Spending]:[Areas of Project Spending], @cell = PERSONNEL@row, [Expense Date]:[Expense Date],…
Manually enter dates in a column that has a formula?
Hi, I created a formula (with SS Community's help- thank you) for a date column that works great for what it was intended for. However, I now realize that date column also needs to be able to be changed manually. Is that possible - to have both a formula create a date but also be able to enter one manually? I saw some talk…
Parent row in report
Hi i have a sheet with ~2000 rows and ~1200 tasks. each task is assigned to worker. the worker need to see only the culomn that i choose in report and update only one checkbox column. the issue is that i want to display to worker the parent rows... and in report i not assigned the worker in parent row.... ony the specific…
Update Requests - Displaying (via Reports or Dashboard)
Does anyone know if there's a way to Display Pending Update Requests? We're using a lot of automation to send out Update Requests to team members, and I'm concerned that they're going to get lost in emails. It would be great if I could build a report, dashboard, etc. that showed all the Pending Update Requests. Mike