-
Use dependencies to set start and end dates independently
how can i use dependencies to help set both a tasks start AND end date independently (not using duration)? As an example, i would like row 3 start date to be row 2 start + 5 (I can get that by setting predecessor = 2SS+5), but I want row 3 end date to autopopulate with row 4 start date.
-
Predecessors Drop down list like MS Project
It would be a tremendous help in creating and maintain project schedules having the dropdown like in Project for selecting Predecessors it is very time consuming to have to jump out or have a second screen open to fined what needs added. This would be a huge help in schedule creation and monitoring.
-
How can I get this formula to work
Hi, I still have a lot to learn in Smartsheet, but I have been using co-pilot to assist. However, I need help with this formula that I cannot get to work. My goal is to strip the site names off any special characters expect for the first four letters# and "offnet. I'll appreciate the any assistance that can be provided to…
-
Save & Resume Update Requests + Automation for Unchanged Rows
I’m currently building a Client Health Report where CSMs provide monthly updates across their clients. Challenge #1: No “Save & Resume” for Update Requests Many CSMs manage a large number of accounts and don’t always have time to complete an update request in one sitting. Right now, they must submit everything at once,…
-
Incurred hours not showing for future dates within the same month
Hi everyone, We are using Smartsheet Resource Management for capacity planning, operational follow‑up, and monthly financial reporting, and we have a recurring challenge related to how Incurred Hours are handled in reports. We understand that incurred hours are date‑driven (past vs. future), and that this behavior is…
-
COLLECT function and validate ISDATE
Hi, I am new to Smartsheet. I am trying ISDATE(COLLECT( function to pull an array and validate whether the values are dates. Is there a workaround? Similarly COLLECT(REPLACE( is there a workaround to modify the array?
-
Merged: Workback Schedule
This discussion has been merged.
-
CTRL+e for details conflicts with Chrome Browser shortcut / hotkey
Typing CTRL-e in the Chrome Browser opens a Google Search in the address bar instead of showing the details view in Smartsheet as intended. Can you think of any way around this conflict?
-
I need technical support
I have a Basic support plan, which is supposed to allow me to create a support case, but the Contact Support page (though it has a link to create a ticket) cyclically sends me to the AI bot that doesn't help. After an hour of frustrating back and forth, it just terminated the chat (though it said it was transferring me to…
-
Automatic email replies going to personal inbox
Good morning, Smartsheet community! I work at a community college and recently began utilizing the Smartsheet automations to send email reminders to our specialty program students. In the email body, we provide an email they should contact with any questions they have. However, I have had some students reply to the…
-
Automation Message to specific contact with only their relavant entries
I have a grid with date from multiple users. I want to be able to send out a message each month to the user showing only the entries they provided. For example, Leo would get one message showing his client, date, program name and #_participants. While Sandy would get one message with the two different clients and the…
-
Enable attachments in automations when using 'message only' option
We receive data from externals which we then need to verify. Once it's verified we then email them back a PDF (that's been generated using 'generate document' feature) as it contains the crucial information that's been verified, and they can keep as a confirmation. Currently, I use the message only format in an alert…
-
Merged: SHARE A FOLDER WITHIN A WORKSPACE
This discussion has been merged.
-
Bridge Search Sheet module - Filter by Date value
Hello. My LOB uses Smartsheet as a form of staff management system. This includes essentially creating a Workforce Management (WFM) tool in Smartsheet. Using Bridge I have managed to automate many of the daily attendance process and am now looking to add a flow to auto update time off requests to approved for future dates…
-
Login OK but not able to edit any work
I am able to open smartsheet and my account shows that my license is active but I am not able to edit any of the documents that I created 2 weeks ago. I am new to smartsheet so would appreciate any help anyone can provide. I get the following error: I filled out a support request but no response.
-
Administrator Control on License Banner
Dear Smartsheet, You really need to add an administrator-controlled option to manage the license banner display for free users. The banner not being able to be removed by the administrators presupposes that the administrator wants the free users to have licenses. One of the main reasons we love Smartsheet is the ability to…
-
Where to start with Bridge?
Hi folks, I am hoping for a pointer in the right direction. I am new to Bridge and need to build a workflow to a) create a project in Resource Management (RM) when the status on a row in Core changes to "Create" and then a follow on workflow that when any of the fields in Core update, reflect those in RM. The challenge I…
-
Can I create dashboards across workspaces
Am I able to create a dashboard, aggregating projects across multiple workspaces? My team is currently building a dashboard, but our projects aren't on the same workspaces, and don't have the same user permissions for all.
-
Merged: Enhanced Report and Sheet Filters for Dates
This discussion has been merged.
-
Lag in Dependencies AND elapsed days in the Duration
There has been a recent change within the last month or so that caused rows that were using lag in the dependency AND elapsed days in the duration column (which is an INCREDIBLY common occurrence in our project plans). This recent change has now messed with all dates both past and future that are either directly or…