-
"Send Row" opens Pop Up Window from Sight
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…
-
Rounding ONLY Up
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…
-
notification to Onwer
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.…
-
cell date recorded when adjacent cell status changes
i am wanting to capture the date when the status of a cell changes. is this possible? if so how do i do this?
-
1 Sheet on multiple worspaces
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 cannot get the search query api to work - it gives partial matches
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":…
-
Mandatory Cells
I've done a formula to add "date required" 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…
-
Report when scanned code
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)?
-
Gantt View Shaded Rows
Whay are some rows in Gantt view shaded, others not?
-
COUNTIF using Parent Rows Only
I am trying to come up with a formula that would count only the parents rows.
