Hello, I am trying to manage requests from a customer with my local team of people who work on the requests. I love the comments, attachments, that can be added into a row, and the ability to create a sight with different reports. I have created a web form for my customer to input requests, but I would like a clean way for…
Hello, I have a construction equipment management sheet and I am trying to create a customized rounding formula for the "months rented" cell. Equipment rentals usually charge at intervals of 1-week, after that at 2-week, then after that at 1-month. Because of this, having a value like "1.3 or 1.6 months rented" doesn't…
I'd like to see if I a notification is sent to the Owner of a row when something changes on it it. For example if another owner or the admin changes the description or if a start or end date changes due to a Gantt or Calendar change, urgency changes etc. Also is there away to send a notification to athe oner of a new row.…
i am wanting to capture the date when the status of a cell changes. is this possible? if so how do i do this?
I am having problems trying to find a way to share 1 sheet to multiple workspaces, if this is even possible. Anyone have any ideas?
I've tried using postman and single and double quotes do not make any difference either I can filter the results but it seems like i must be doing something wrong https://api.smartsheet.com/2.0/search/sheets/798272320235396?query="'Elliott'" returns { "results": [ { "text": "White cottage", "objectType": "row", "objectId":…
我做了一个公式添加“日期要求ed" when the box is checked and " " (blank) when date is not checked. Issue is when the user puts the date in the field, it removes the formula, so if they unchecked the check box, or remove the date, the date remains blank. Although I have formatted the cell to stay Red if blank, I'm…
Is it possible to get a report / notification in SmartSheet if a qr-code or any other code is scanned by a smartphone (android or iPhone)?
Whay are some rows in Gantt view shaded, others not?
I am trying to come up with a formula that would count only the parents rows.