-
How to clear the clipboard?
Hi there, I am having difficulties with copy & pasting from one sheet to another, i.e. when I copy some new cells it still pastes the previous cells that I pasted. Does anyone know how to overcome this / clear the clipboard? Thanks, Paul
-
Angular JS
Does anyone know if you can use the smartsheet api for nodeJS with Angular?
-
Email alert when not modified
Hi All i have created a card view that are work packages for staff, i am requiring them to update the cards every 7/14 days with status and commentary. is their a way to build an alert that sends an email to either myself and/or the assigned staff member that lets them know the card has not been updated, additionally in…
-
Reminders - view sent reminders
Is there a way to keep track of reminders that have been sent? It appears they go away once sent and there isn't anything that shows they were setup/sent. Would like to be able to confirm that reminders went out.
-
Links in webforms that link to OTHER webforms
Hi there, One of my clients has many events that occur at their main event. I have created a webform for the various stakeholders to request catering, AV, etc. I had challenges in distilling the data down to a usable function. There were 85 columns because I had to much information in one place. I created other sheets that…
-
Project Management
Hi, we currently have a few web forms, that allow clients to request quotes. These then populate fields on a smartsheet as normal. We have two challenges that I'd like to implement but can't seem to get it right. We would like to give the client more visibility on the status of the opportunities, but for various reasons,…
-
Create notification
Hi, I create the notification. I know that the receipt should be collaborator (mean the smartsheet shared with them). However, may I ask if they are set as "Viewer", can they still get notification. I have may be more than 10 people will receive notification...so, I need to know all level (editor, viewer) can receive…
-
Constructing URLs to particular rows in sheets
Hello, I am collaborating in a project and most of the work being conducted is external to SmartSheets, which is being used as a planning tool. I would like the ability to construct an URL / Hyperlink that references particular tasks / rows. The idea is that as the project SmartSheet gets extremely big and with multiple…
-
Sumif help
Hi, I am trying to show a rolling 6 months resource allocation matrix, so that I am able to include the resource allocation figure on the dashboard and need some help with the formula that will be required. Tried the formula in the snap shot, but it does not seem to work =SUMIFS([Resource Duration]7:[Resource Duration]23),…
-
Netdays - if blank
Hello all -- I have created a column to show me how many days between "today" and the expected close date of a sale. This is the formula I'm using: =NETDAYS(TODAY(), Close Date16) This is working, but I have one problem: I don't always have an expected close date. In those situations, I want the cell to display as blank.…