-
NEW: Get Help page in the Community
Hey Community, It's been incredible seeing the growth in members and discussions here in the Community over the last few years. Based on your feedback, we've expanded to have multiple ways to join in, engage, and connect with fellow members! Today we have a new page for you to check out: a section specific to support: Get…
-
Start date auto update?
Hi, everyone. I'm very new to using Smartsheet and am having some troubles regarding start/finish dates. I'm trying to find and use the correct formula/automation to change the start dates if the previous job task has run over its allocated time. For example, I use Smartsheet to schedule trades for job sites, if a tiler…
-
Can you Log a Cell In time?
Within my project sheet I have formulas set up to show me the present of Target duration vs actual completion date. The parentage in cell will change as we close out projects. Is there a way to track/Log this cell as it changes so that I can create a line graph to see our patterns over time?
-
Technical Support Horrible
We are new to Smartsheet and we are on an Enterprise plan. I had three interactions with support so far and all three have been horrible. First one was regarding this: Populating Contact List Dropdown — Smartsheet Community. I got more information from the community than the actual support case I opened online. The…
-
Gantt Chart Display and Behavior - Open to today's date mysteriously gets unchecked.
After I have checked Open to today's date for my project setting, it gets unchecked in a couple of minutes. Is anyone else experiencing this? https://help.smartsheet.com/articles/765755-modifying-project-settings#toc-customize-the-gantt-chart-display-and-behavior
-
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.
