-
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…
-
find deleated items
I am looking for a way to track items logged on a web form or a way to find if a line item has been deleted
-
Excel Compatible Symbols
Hi there, I am creating a sheet for a project that I will need to export to Excel for poeple outside of my company to use and I was wondering if there are any symbols that are compatible with an export to Excel ie. would look the same. Thanks in advance, Graham
-
numbering child rows
I have a sheet I've been using for a while. I just added a column and set it up to auto number. All the rows increased sequentially, e.g. 1, 2, 3 etc. The child rows, and their child rows continued in orer, in otherwords the child of parent row #1 was #2. I'd like the child of Row #1, to be 1.1 or something like that. Be…