-
Repeating References relational Database
I want to create a list of unique references, and then use that list to populate multiple other smartsheets, for items that use that reference. How do i do that?
-
COUNTIFS + AND + DATE RANGES
Hi! and HELP! :/ I'm trying to pull data from a tracker that counts issues that take longer than 2 days to resolve, for a specific company, within a month. Below is an example of what I have tried. I've tweaked, re-done, ad nauseum... I can get the company + days and I can get the dates, but when I try and marry them up…
-
Currency conversation using a table in a separate sheet
I would like to use collect/look-up to reference and convert amounts into USD. Columns on the sheet where the conversation needs to take place: Reimbursement Amount Currency 3-letter code If the 3 letter code is USD, copy the amount, if it is not USD, it needs to look up 3-letter code and times it by the conversation rate.…
-
Counting Check Boxes in Children
I have found other threads for this, and tried this formula =COUNTIFS(DESCENDANTS(), 1) However, I get error #BOOLEAN EXPECTED I have parent rows and grandparent that I would like to calculate
-
How to highlight the values in the column which is greater than or less than the other column values
Suppose, the order quantity we have taken from the customer is 500, and the quantity we have placed an order with our supplier is 600 how to highlight this excess quantity?
-
Automate Update Requests
Hello, I am trying to implement an update process for our Staff Forecast Tracking Data Input sheet. For each project (grey rows), I would like to assign someone to update all the project staff's LOEs on a monthly basis. For example, an update request would go out to a specific staff member to update the 4/24 column of LOEs…
-
Convert into a formula column
HI, i'm new to spreadsheet, currently i'm on trial version (30days Trial) planning to buy after using it like one week, yesterday i've noticed i cannot convert text/number column into formula column it's greyed out. i've tried with different sheets different cell types it's still greyed out, please help out. Thanks Vinoth
-
Formula column disabled (greyed out)
HI, i'm new to spreadsheet, currently i'm on trial version (30days Trial) planning to buy after using it like one week, yesterday i've noticed i cannot convert text/number column into formula column it's greyed out. i've tried with different sheets different cell types it's still greyed out, please help out. Thanks Vinoth
-
COUNTIFS with DATE
Another day, another question to the Community...! I'm trying to get a count of all jobs starting in each month. My formula is giving me an #INVALID OPERATION error though. =COUNTIFS({Start Date} >= (DATE(2019, 1, 1)), {Start Date}, <=(DATE(2019, 1, 31))) What am I doing wrong?
-
Creating a Skill Grid for tracking
So, I am trying to create something similar to what I have in Excel in Smartsheet where it looks to match two things and if both are present it returns true, if not then false. The problem is it is referencing another sheet for both things. For instance, If Paul's name exists, and he has a date in Column 2, then true. Is…