-
Count if formulas
Hello, I have a fairly simple formula that I need assistance with. I have a 'Date completed' column (UK Date format) and a check box column, 'Test1'. I want to do a count in a separate cell for all the rows that have check boxes ticked for within specified month period. E.g. Count the number of test completed in May. I…
-
Ideas on transition between annual project tracker sheets
Hello, I am looking for a way to "connect" two Smartsheets that track a variety of projects (one for 2019, one for 2020). Curious to see if anyone has done this, recognizing that some work may extend into the next year, and if there are any lessons learned / pro-tips in creating and maintaining such a concept. Thanks for…
-
Workspaces do not appear on "link to" file list
In taking the eAcademy course, in the Cell Linking chapter, I am told to link to a file in the eAcademy workspace. When I try to do that, I notice that I have no access to any workspaces from the link to functionality. I can get my learning about this concept from the class. My concern is, moving forward, will I not have…
-
Relational database / multiple values on sheet 2 linked to sheet 1
Hi Is it possible (and if not could it be?) to edit the value in a cell of a column that does not appear on the original sheet where a line in a report is pulled from? In other words, I'd like to emulate a 'relational' database. The use case is that we'd like to log results, measured using a series of indicators, of…
-
Smartsheet relational database
Hi all, Im wondering if it is possible to set up a relational database using smartsheet and cross referencing other tables (which it looks like it is), however, i'd like to also be able to query these tables for specific data. Is there a way to query linked sheets or does anyone have suggestions for tools to use in…
-
auto update from multiple sheet
Hi, i'm looking for someone who can help out in setting up smartsheet for the company.
-
Cross-sheet references
I'm getting the error code #CALCULATING, which I think is because I must've gone over the 25,000 limit for cross-sheet references. The sheet originally had upward if 4500 rows and I've removed more than half of them now but I'm still getting the same error. Can anyone help with this please?
-
'Find & Replace' functionality in SmartSheet?
Is there a way to use a 'find and replace' functionality across the entire estate of worksheets through utilising Dynamic View coupled with Reports?
-
JIRA Pro Fields
Has anyone used JIRA connector to update cells in Smartsheet from Pro Fields? This is a main functional requirement of our use of the integration tool and really want it to work if possible...Thanks!
-
Using COUNTIFs with FIND & AND
Hi, I need to add up the following: 1) All Labeled as Country X from a Qualitative field that is requiring me to use the FIND function. 2) All labeled as AreaY across 3 columns (I have tried selecting all columns as a range and also just selecting the relevant rows as well). Currently using: =COUNTIFS({Consultant…
