Agriculture
Discussion List
-
Document Checklist(s)In Formulas and FunctionsHi all I am looking for the best way to create a document tracking checklist that tracks all necessary documents in our loan origination process for EACH applicant that may be on the loan. There could be 1 applicant or there could be 5. W…
-
Circular Reference Won't Go AwayIn Formulas and FunctionsHi, I'm working on fairly large sheets that reference many other sheets. My main summary sheet is doing SUMIFS formulas to summarize and sum to a higher level. The summary sheet column is showing a Circular Reference error. I found …
-
Number and Fraction FormatIn Archived 2017 PostsWe currently use a considerable number of sheets that need numbers to read as fractions. (Construction/Exhibit Industry for dimensions) Unfortunately, if you type out a number as a fraction it cannot be used in formula. Excel can transla…
-
Formula to automatically check a box when a certain cell is populatedIn Formulas and FunctionsI am trying to get a column to automatically check a box when certain cells are populated in the same row. This is linked to an update request situation. Basically, when an update request is fulfilled, OR when a certain cell has informatio…
-
Two different triggers for one check boxIn Formulas and FunctionsHello, I find this community very helpful in the search function, but I haven't participated much with my own questions. I'm hoping you can help. I have one check box that I would like to be triggered in two different situations "thi…
-
OR function to check a boxIn Formulas and FunctionsI am trying to get one box to check under one or another conditions. 1. when a certain cell has any text 2. When another certain box is checked The function I came up with follows, but it doesn't seem to work. There might be one small t…
-
Options to display all formulas/functions in a sheetIn Formulas and FunctionsHi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy …
-
Displaying multiple column values in Calendar viewIn Archived 2015 PostsI am storing data related to issues in the smartsheets. How can I show the issue number and priority in the calendar view?
-
Auto Assign a Predecessor in GanttIn Using SmartsheetHi, I have a series of standard processes that have the same dependency and predecessor data each time. I have the primary column as a job number, and then a second column with a drop down list of all the standard processes (I.e. assem…
-
Customer DatabaseIn Using SmartsheetI'm looking for a way to track our applicant demographics. Any one have any ideas to track all your customers in one place?
