-
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.
-
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…
-
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.
-
Merged: Version History
This discussion has been merged.
-
Prevent Unintended Changes by Disabling Removal of Logic when renaming dropdown items
I was editing the value fields within the column. One of the dropdown answer choices was “New Request”. I simply just added a new word “New/Continuation Request”. When I added the new word, that’s when I found all of the associated logic removed. I never removed a field so in theory, the associated logic shouldn’t have…
-
"copy row to another sheet" - Sometimes row gets copied down at the bottom?
Hi, When there is a workflow to copy a row to another sheet, why does the copied row sometimes appear down at the bottom of the sheet, leaving ~50 completely empty rows in-between the last row or text? I know technically smartsheet must be sensing that the rows in-between are not empty, but does anyone know what causes…