-
Help to understand webhook callback JSON
API Webhooks sends Sheet column update callback JSON with multiple row and cell objects as marked updated. How do you find the correct rowID to get column values for the updated row? For example, I changed the status of one row column from A to B and received the following JSON from webhook callback: Body:…
-
Transferring ownership of Workspace easily?
Is there a way to transfer ownership of a workspace without having to remove the current owner from the workspace? They still need to own specific sheets, and edit others in the workspace, but do not need to own and administer the workspace anymore.
-
Changing the display of text / image in scheduled reminders
Hi I have a smartsheet set up, and off the back of it, I have a set of monthly reports set up. I am sending my users reminders on a weekly basis, with the reminder containing the url links to the smartsheet and that month's report. For some reason, when users receive the reminder, in addition to the message and the the…
-
Formatting trouble
If you have created conditional formatting to color alternating rows a different colors, how do you format the document to automatically adjust colors when a new row is added?
-
Add requirement to formula is a cell is blank versus not blank
Here is what I am trying to do for our contracts: Cells I'm working with (for the formula) • Contract Start {Date} • Contract End {Date} • Remaining Days {Number} // formula =[Contract End]1 - TODAY() • Contract Status {Dropdown - see below} // formula =IF([Remaining Days]1 < 0, "Expired Contract", IF([Remaining Days]1 >…
-
Can you concatenate in SS?
For example: Column A says "John" Column B says "Smith" Can column C read "John Smith"?
-
Hierarchy from Excel
Hi all, I have an Excel sheet that I export from TFS and has a hierarchy defined. I would like to copy it into Smartsheet and maintain that hierarchy without having to manually recreate it. Can this be done? I am not opposed to using Excel to reformat appropriately. I am just trying to avoid recreating the hierarchy every…
-
Odd behavior - I thought it was just me
Recently (last few weeks or so, maybe less - time is blurry to me), I've been noticing odd behavior on Smartsheet. Things like an open dialog (attachment summary for example) would just close. Did I click something? I'd look down at my hand to see if it has taken a life of its own. I don't THINK so. But maybe I'm crazy.…
-
Error message on deleting attachments
I was going to delete attachments from the Workspace Attachment Summary window. I had attached a HowTo document to a Master sheet -- and each time a new sheet was created, the attachment came with it. So, time for cleanup and a change to my process. I selected the 6 attachments and selected "Delete All" as some had…
-
Misc feature requests
The following features/enhancements would be useful: * -Card view also for reports * - Conditional formatting applied in reports * - BOX task integration (tasks assigned in BOX could be displayed as a separate report) * - Reports from reports, not only from sheets. This would enable more advanced filtering * - A report…