-
Aggregate all the amounts tied to the Client Id's in another column
This discussion was created from comments split from: Use Sumifs and Index Match to add values in a multiselect lookup table.
-
Sending Slack messages directly to specific users
I've enabled slack direct messaging from smartsheets (via enabling Messaging Apps in my Notifications settings) but if I'm reading my research correctly, this functionality is only available to Smartsheet EU users and not US/Canadian users - do I understand that correctly? I'm trying to setup an automation that triggers a…
-
How to subtract the 6month before end date
hi everyone. I've been trying to calculate on how I can get the 6months before end date to set a reminder before the end date comes. Can anyone help me. Thanks
-
Date Formula
Hi Brian Trust I am needing a date formula that is a bit over my head So IF Jan Due is a date then subtract Jan actual from Jan Due date (using Jan Variance column) BUT if Jan Due date is blank report a blank AND if Jan Actual Date is not a date then report "OVERDUE" in the Jan Variance Column I have so far but is not…
-
Share to Domain / All / Enterprise / Everyone
The ability to share to everyone in your account possibly using Domain (similar to Dynamic View). Perhaps only allow System Admin to set this up for security. We have an Enterprise Plan and I was looking for a method to share a sheet to everyone as viewer. We have a lot of people and creating and maintaining a group for…
-
Share Editing of Groups in Group Management
Creating groups in group management is how we are managing access permissions to work apps. We have a couple of people who help maintain the workapps so that we maintain coverage when staff are not available (on leave, in meetings, etc). We need the ability to edit other users groups in group management. Is this possible?…
-
Standardizing Date Formats in Sheets to YY/MM/DD
The Date column's format is not consistent. My default regional setting is Korea, so I think the date should be displayed in the YY/MM/DD format. However, some Date columns appear in the DD/MM/YY format, while others are in YY/MM/DD. It seems that the default is the DD/MM/YY format, and the format of some Date columns…
-
Workday function
I want to calculate the working days from the start date. However, we have Sat as a working day which I have configured in the Gantt setting. (So we have 6 working days). When I use the formula WORKDAY ([Start Date],38), from 3-Mar-2024, I get the output as 16-Apr-2024 - which is correct. 3-Mar-2024 being Sunday. When I…
-
Copy and Paste from Excel into Smartsheet Project
Hi, I have a smartsheet project and am wanting to copy and paste multiple cells from a MS excel document into the 'task name' column. Can this be done ? Thank you Alan
-
Adding Image to Cell from gdrive URL automatically using Python & Smartsheet API
Hi All, I am currently trying to automatically adding image into a cell in smartsheet using Smartsheet API and Python. So, we have two column : Column A containing image URL Column B where we want to add the image from gdrive URL I have hundred rows, meaning we have hundreds cell on column B to add image from column A. I…