-
If/Or Formula
Good morning, Community! The intent of the formula below is if the HRSA (P) is either OCS or OLCP then the Non-LIP column should by "Y" otherwise, it should be "N". With the current syntax though, I'm getting an #UNPARSEABLE error and could use an assist, please.
-
Long Mobile Form times out and erases data
I am using a form on the mobile app that has approx. 100 fields that takes someone an hour to fill out sometimes with 5-10 minute pauses in between filling fields. It is for a multiple building property inspection so they have to drive a golf cart between buildings to check the different things that are asked in the form…
-
keeping columns hidden
Hello, I have three sheets A, B, and C where an automation copies a row from A to B or A to C when certain conditions are met. Sheet A has three columns, "occupation 1," "occupation 2," "occupation 3" where only one value is present in one of the three cells. I have a formula that copies the value from the cell that is not…
-
Drop down in one cell not a whole role
Hi I'm looking to have the top section of a sheet to hold information for a whole project with the line detail under. Like in excel is there away just to have a drop downs for cells not whole rows? Thanks Joan
-
Automated Update Requests Are Not Working
Hello, I have been having a lot of trouble with my automated updated requests sending email notifications. I have created new ones and everything. Sometimes they will send and sometimes they won't. The update request is created, however, I need it to trigger an email, which it does 30% of the time. It is a simple…
-
Link Dependency Lead/Lag Times to a cell value?
Is there a way to link a row's dependencies' lead/lag time to a calculated value? The only way I see to change that value is by editing the dependency directly. It would be helpful to be able to calculate what the lead or lag is based on a number of factors. Is that possible?
-
Report / Dashboard - Grouping option not working
I added a grouping in a report to organize the display in a dashboard. I want to group the report by type of project and for each type of project sort by go live date. When I am in the report, the grouping works. However when I pull the report in a dashboard, the grouping is not taken into account, only the sort by go live…
-
Automatically approve for one user?
Hello, I think I know the answer but I wanted to ask the gurus! We have a vacation approval application that has a calendar app associated with it so all users can see when anyone is out of the office. Everyone is using the app, right to the top of that organization. Everyone BUT the person at the top has a designated…
-
Cross sheet countifs
Hi, Attempting cross sheet counts for totals by month and year the number of times "x" appears, in the example below I selected "DTS" from the other sheet. I can get the total column count from the other sheet with =COUNTIFS({Container COMPLETED Range 2}, "DTS") but when I add all in italic below I get #Unparseable. I have…
-
In mobile app, search the data through the scanning the barcode
Hello Everyone, Hope you doing great In my sheet, I am using a form through which users need to scan the barcode for the Product number and update the status of the respective stage of the Process. In the Smartsheet app, I opened the sheet in mobile view and I search the Product number through the barcode scanning option.…
