-
Smartsheet Calendar Embeddd on to Sharepoint... Frozen
Hi! I have embedded a Smartsheet calendar view from a report on to Sharepoint. It loads the calendar but is frozen. I can't scroll up or down. Other people in my department experience the same issue. Not sure how to fix it.. Thanks!
-
Set Slack Automations to Tag a User
Is there a way to tag a user in an automated Slack message? I'm trying to send a form response alert to a Slack channel, then tag the user in Slack if certain criteria are met. I tried using the @user in the message text, but it is treated as standard text rather than a tag.
-
EXCEL IF FUNCTION TO SMARSHEET
Hi, I've tried everything and I still can't make a formula work in Smartsheet. Formula in EXCEL: =IF(K269>0;IF(K269>J269;"DELAYED";"ON TIME");"") Formula in SMARTSHEET: =IF([Doc completed]@row > 0, IF([Doc completed]@row > [Deadline for doc]@row, "DELAYED", "ON TIME"), " ") So if document completed date is not empty, than…
-
Date format on email
Hello again, I have an automated workflow that sends out an email to a contact list and includes one of the cells in my sheet which is date. The way it is displayed in the email is MM/DD/YYYY although the cell format is MONTH DD, YYYY (i.e. February 5, 2021) Is there a way for the date to be displayed on the same format in…
-
Is there a limit on how many conditional formatting rules I can have?
I'm about to embark on created hundreds & hundreds of conditional formatting rules for a big full year shift planner sheet I'm creating. It's a massive faff, and It'd be great if I could just select a range of cells like you can in Excel, instead of being limited to just one chosen column. But that's not going to change…
-
Set up an attestation?
Hello Smartsheets Community, My company would like to have everyone in our organization complete an attestation that they agree to a new company change. Originally, I was thinking of sending a form to the whole company, and having everyone check off a box that says something like "I Agree." However, now I am thinking it…
-
due date email reminder- any option to send it item by item?
Hi, I am trying to set an automation function, to send email reminders to task assignee on due date. the scenario: there are multiple tasks (say 4 tasks) assigned to one person (say David), all 4 tasks has the same due date I found that the system will send ONE email with FOUR items included to remind David on due date. is…
-
Request or Transfer Workspace Ownership in Smartsheet
Hi Community, Great news! As a licensed user, you can now request ownership of a workspace from the current owner, or transfer ownership of a workspace that you own to a new owner. Now, if someone leaves the organization, or project ownership changes, you can ensure your workspace (and optionally, the items you own within…
-
Is it possible to automatically create a google event link by filling out a form?
I have this form that I have applicants fill out for a job. I want it to automatically create a google event and send the link to the applicant. I do not know if this is possible, but I am trying to figure out the best way to do it or the closest solution. Thank you!
-
Help to show Gantt View horizontally rather than stacked
Hi everyone. Any thoughts on how I could accomplish this (or if it's possible at all)? Thanks.
