Ultimately, I want to indicate to users when a cell will be automatically calculated, so they don't overwrite the formula. I've figured it out in one case, but not in another. Both are shown below. So…
In a form. I want to add data from one sheet and popluate another sheet, the issue i am having is the form sheet receives new requests each day. Where and how do i change the formula below to capture …
Hello everyone and thanks for any help you might be able to provide me, with my project. What I am trying to do is update a single sheet and have as much of that information populate another sheet as …
I have multiple editors who make changes. Assume that I cannot trust all of them. In this scenario, I would like daily versions to be saved (not eternally, but maybe for the past week) and permanently…
Found that if you enter a zero formatted as an integer into a cell using smartsheet.csharp.sdk.2.83.0 and don't turn strict off any formula referencing that cell will fail with Invalid Operation as I'…
I am going on vacation and realized that my smartsheets need someone to manage them while I'm away. The only way I was this was to manually update every automation that includes me and add my vacation…
=COUNT(COLLECT({ContractPayments Range 3}, {ContractPayments Range 1}, Agreement@row)) Above formula works fine, but I want to add another criteria to it where I check if a Date column value exists. I…
Okay, I'm trying to write a formula to automatically populate a contact based off the information selected in a multi drop down. I have a separate sheet that lists the appropriate contact for each ite…
I want to look up a value from a dropdown in one column and enter text into another column based on the value found in the first column - is this possible? I can't seem to work it out! For example, if…
I need a way to match a list of volunteers to meetings in their area. Sheet A houses volunteer information, and the input is a Smartsheet form. Very basic, houses employee info and state (has multiple…