-
Document the value of function / calculated field every day
Hi all, I have 2 sheets: 1) working sheet where all tickets are logged + their status is maintained 2) calculation sheet with fields showing e.g. number of open / closed tickets and so on (calculated by formulas which refer to the working sheet 1). These values are used for dashboards and so on. I wish to automatically…
-
Weekly date with manual override
I'm looking to create a formula to have a cell show a date for when our next delivery comes in. Typically these deliveries are every Tuesday, but sometimes they are late by 1 day, or we skip a week because we don't need it. I would like a cell to show the next estimated delivery date example. Today the cell would show:…
-
Using DISTINCT function
I am trying to use the distinct function. It seems like it should be relatively simple, but I am getting an error message. Am I doing something wrong? Thanks
-
Merged: Add Attachments to Automated Email/Workflow
This discussion has been merged.
-
Workaround Needed for Smartsheet Issue with Primary Columns
A report must use a sheet’s primary column and the primary column must be in the first report column. Labels for report groups are displayed in the report’s primary column, so if you don’t want to view the primary column in the report, or hide the primary column, then the groups’ labels will be hidden. If you copy the rows…
-
Sending a single email to multiple people
Hi, I have several automations set up to email coworkers. However, usually I need everyone to be literally on the same email. I understand that ultimately smartsheets wants/thinks people are going into smartsheets to "work" but sometimes that's not the case, sometimes you have people outside your organization or whathave…
-
Adding an Attachment via API (Python)
Hello all, Apologies in advance for what will be a basic question for some, however I am going insane trying to figure this out. Struggling to add an attachment via the API, have been on the Github and the Getting Started resources provided by Smartsheet and still no joy. It is completely down to a lack of experience with…
-
How do you limit items in a dropdown menu field based on the selection of another?
We're building a process where users are limited to a secondary dropdown menu selection after selecting an option from another dropdown field. For example: We have a Job Department field and a Job Type field. If the Job Department dropdown menu includes Accounting, HR, IT, etc., we want the Job Type field to be limited to…
-
Item Request
Hello, I am creating an item request/reservation form for check out/in of a limited number of headsets, 6 items. I am trying to determine a way for the sheet automation to look at the date a headset is requested and send a confirmation if that date is available for one or a denial if all six are already reserved for that…
-
Merged: DataShuttle Workflow Errors (Action:Replace)
This discussion has been merged.