-
Is it possible to use a formula to help users complete a form?
We are asking for updates to quality documents. The form asks for the document number and the title. Is there way to auto-populate the title in the Form once the number is entered?
-
Conditional Linking?
Hello, I was wondering if there was a way to unLink cells if a condition is met, i.e. if Column1 is checked then UnLink all cells in all rows this would be to lock values coming in once checked or if that is NOT possible ... If a value that comes into a linked cell (from another sheet source) is say $10 and I set up an…
-
Locking or freezing the TODAY() formula
Good day all, I've looked around in the community about locking or freezing a current date, but I'm still having issues. My goal is to lock a start date that's triggered by entering a X and have that current date freeze until the x is removed. When an X is entered in the Visit column, that triggers a start date to…
-
"Live Date" is 4 weeks from "Submitted Date"
Hi, I'd like to set up conditional formatting to let me know if the "Live Date" column on my grid is indeed 4 weeks from the "Submitted Date" (Submitted is an auto-populated cell if that matters.) I know I need a helper column, and I know how to do greater than, less than, equal to with an =IF statement, but how do I set…
-
Finding duplicates and checcking blank cells
Hi there, I am at my wits end and I think it is a very easy solution, however I cant see it. I have a column of project numbers, and I am trying to see if there are any duplicates, as well as if the project number cell is black, to leave it blank. What I have done is sort the project number column in ascending order and in…
-
How can I remove a sheet reference, so I do not receive the alert ‘Reference a total of 25000 cells
Background: An International source Smartsheet has 1700 rows (and counting) and 85 columns. Using the Index/Match formula, we reference 14 columns of data within a new Regional Smartsheet. Why? Regions want to add additional Country-focused data, data that should not be managed on an International sheet that already has 85…
-
How to indicate that a cell will be automatically calculated?
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, more specifically, any ideas on how to detect a blank cell when using =MAX(DESCENDANTS()) in a Date column? I have a…
-
Formulas
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 all new data in the sheet. I though i would use the $ or @row, this only issue is i have a summary line at the top of my…
-
Pulling from another sheet based on conditions
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 can, but only if the customer is a certain one AND the "SFDC Category" = "Closed Won". Here is what the first part of my…
-
Formula fails when zero is entered through API unless strict is turned off
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'm assuming it is recognizing as text. If strict is set to false however the formula's will work correctly. Looknig at the…