Legal
Discussion List
- I'm really struggling to get the syntax right on this. I have a column called "% Complete" and a due date column called "Finish." If the % Complete < 100 and the due date is today or already passed, I…
- Hi, I want to identify rows that have a duplicate entry in a column entitled "Bill Number". How can I create a workaround formula to notify me when there is a duplicate? I believe the best way is to u…
- Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basically, i need to c…
- I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would er…
- I'm trying to create an Update Request notification for certain rows in my sheet, but to be sent out on either a quarterly or monthly basis. More specifics--I am in a legal dept at a mortgage company,…
- Hi, all! Our office is new to the SmartSheet community. I am having some trouble creating a formula for a sheet. I have the following columns: * "Initial Contact" - formatted as a date * "30 Days Sinc…
- I'm trying to count the number of items in a column where part of the text shows. Is there a way to do this? For e.g., I'd like it to count up the number of rows from a column in which the words "ids"…
- Hello All, We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process. Wondering if anyone in the community that has a DMS in place can…
- Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multi…
