-
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.
-
Auto Fill Dates
I am trying to have cell automatically fill the following dates: * First day of the current week (i.e Monday) * Last day of the current week (i.e Sunday) * * First day of the next week (i.e Monday) * Last day of the next week (i.e Sunday) * * First day of the previous week (i.e Monday) * Last day of the previous week (i.e…
-
Schedule Duration Issues
I've been working in a CPM schedule. The original showed a 141 day duration, starting 12/12 and ending 05/04. I'm updating some of the relationships as I had to rearrange the work pattern a bit, now my schedule shows 144 days, starting 12/12 and ending 6/29. Does anyone have an answer as to how I gained only 3 days…