-
Date Range Conflict - Vacation Request Sheet
Hello, I've seen quite a few questions for date range overlap, but couldn't find the solution. The closest I found was the one below, but it was referencing another sheet, not the same sheet I believe, and not sure a simple edit to that formula will make it work for me. Form requests will populate new rows of all time off…
-
Search Window Widget for Dashboard
We have a sheet that contains a list of applications, application manufacturers and will contain the link to where software packages for each package are stored in another program. We're looking for a way to provide a keyword search window where the user could type in the application name or manufacturer and view search…
-
Charts
Hi, I can't find a good solution on the below configurations for the formatting of charts with those options available in Excel, is there something I missed? Changing colors of data display (e.g. bars) Changing font size/position of data labels Selecting certain rows in a table for plotting the chart instead of continuous…
-
MULTIPLE ROWS for ONE APPROVAL REQUEST
I submitted enhancement request last June 11th but I have yet to receive a response. I have set up a REQUEST for APPROVAL workflow for "APPROVED", "DECLINED" to our customer. However, the approval request is per "TAG NUMBER " which results to two approval requests. For example, their Preventive Maintenance below schedule…
-
Automatically put new card subtasks under parent level
When I create a new subtask in either card or Gantt view, a new card is created, but it is automatically put at the bottom of all the cards instead of directly under the parent task. Is there a way to change that so that cards for new subtasks are automatically put directly under their parent tasks? Thank you
-
Approval workflow validation
Is there an easy way to validate that a request for approval submitted via a form is not approved by the person who created the request? My sheet contains a Contact List column from which approvers are selected. I have tried to validate this entry against the 'Created By' column but this does not match as the contact list…
-
Regular PDF export
Currently we have a Smartsheet that is scheduled to automatically send a sheet as a PDF attachment to a large number of employees on a weekly basis. For records management purposes and email space reduction purposes, we would like to regularly schedule the creation of a PDF in a shared location that all can access. We…
-
Smartsheet Invoice Reminder
Hi, Is there anyway I can set up an invoice reminder similar to smart sheets? Thanks ]
-
Can I re-use the same approval columns across multiple workflows?
Hi, I've created a Request form and the form submitted needs to be approved by 7 approvers (depending on which team team & scope submitted in the form) So, I created 8 approval workflows. I would like to prevent from adding more columns for approval columns as there are only 7 approvers. Therefore I re-used back the…
-
Formula for weeks
Hi Everyone, I have a grid in which all my truck data goes in every day. For the data that goes into that grid everyday, I have created a column in which I want it to tell me what week of the month it is. I would also like my weeks to work from Sunday to Saturday. So basically for June it shouldve been as follows: 1-6th =…
