-
Paid for ProSupport but can't access it
I upgraded my business plan to include pro support. However, there are no phone numbers listed under the Contact Us section. My only option is to file a support ticket. On 6/5, I emailed Daniel Tiner, the sales rep who completed the purchase for me. I have not received a response. This is very frustrating as I paid for the…
-
Implement the capability to allow records to be moved to a different row and remain intact
This is in reference to the support case #06202095: https://supportportal.smartsheet.com/s/case/5005a00002WaZM4AAN/issue-with-data-insertion-and-moving-them-see-detailed-description Summary of the case I use a plugin called Smartsheet for Jira Connector to sync data between Jira and smartsheet. The issue is that when I…
-
WEEKNUMBER and WEEKDAY
I've built a Smartsheet (with some help from the ProDesk) that assigns a task to a contact based on the date/time of a request. The sheet looks at the date stamp on the request then references another sheet (using WEEKNUMBER and WEEKDAY) to see who's "on duty" at that time. That contact's name is pulled into an "Assigned"…
-
Formula to sum rows from one sheet based on a date range to a field on another sheet
Hi! As a brief summary, I have created a sheet for our laundry staff to keep track of how many items are being laundered on a daily basis. I have created a separate sheet for monthly totals of each item laundered. I am trying to create a formula that will sum the total number for each laundered item within each month. For…
-
Need Formula help!
I need a formula that will do the following: When the Date in WKU column has past place the latest NewPromiseDate from the AllPromiseDates column in the cell.
-
How to return most recent value when conditions met. Smartsheet Support is Stumped
Hello, I stumped Smartsheet Support with this formula question: I want to return the most recent approval status from another column based on common Project ID. I have four columns: Created Date - Project ID - Enter Status - Project Approval Status (Where the formula exists) All the columns are text except for Created…
-
Can I combine multiple rows into one row on a Gantt Chart?
Dear all, I want to aggregate multiple project schedules into a master schedule. When copying the milestones from various projects into a single sheet, my overall Gantt Chart displays an event as a row, and each project occupies many rows. Is there any method to combine multiple rows into one row and use one row to present…
-
Salesforce Connector - Using "Assigned To" field for automated alert
I have an "Assigned To" column mapping both ways from SS to SF for a services team project estimation process. In Smartsheet, the "Assigned To" field has the employee name and email and automated alerts are sent when someone is assigned. However, when the data pushes from Salesforce to Smartsheet, the "Assigned To" name…
-
Form logic is not working
I submitted to tech support 5 days ago when discovered this and still can't get answers. I have built many many forms in the past however the logic is now not working. I dumped the form and started fresh however still has same issue. Logic is that when customer name is blank only Lot-Unit-Development should show however as…
-
End User - Features locked down?
New to Smart Sheet, been using it for roughly 2 months as an end user. I want to like this app and not sure if it's the app itself or if the PM has locked it down so much that it is unusable. First, I can't sort on a "% Complete" column to know what tasks are complete and which need work on (this is on a filter that the PM…
