-
Automatically Updated DropDown List
Hi everyone, I have a drop down list that contains complete, in progress, overdue/delayed, and rescinded. These are displayed in the Status column. I also have a column that lists the due date. When it is one day after the due date, is their a way to automatically have the status column update to overdue/delayed? Thanks
-
Counting Blank Date Cells
I think I am missing a piece. We would like to count blank Date cells. Is this possible? Any variations of Count Ifs I am trying don't work. I think perhaps I am missing something, as this should be straight forward in my head... Thanks for any thoughts or guidance!
-
Utilizing query strings, formulas, and webforms to have a weekly training tracker
Objective: Have a dynamic form autosent and already filled out (mostly) on a weekly basis for a large rolling number of teamembers, while all being managed by the lowest tech savvy group in my organization. In order to complete this I have 3 sheets. training files database. The date field is filled out as far as 2100 andโฆ
-
Count if Critieria with Eliminating duplicates
Hi, I am trying to count how many of my tax id numbers without duplicates from (Column name TIN) that are associated with a certain contract type "AFF" contract (Column AFFDNGEMP). I have tried the Count if formula but it does not give me the number of TINs without duplicates. How can I combine the two formulas so that Iโฆ
-
Contact Column VLOOKUP Not Generating Contact
Hello Smartsheet community, I am having a small struggle with a contact column in one of my sheets. I have a formula: =IFERROR(IF(FDO@row < TODAY(), VLOOKUP([Store Number]@row, {Setup and IT Completed Range 1}, 14, false), VLOOKUP(Location@row, {Setup and IT Dates Range 1}, 13, false)), "") The column it is referencing forโฆ
-
Report from 2 sheets shows same column header twice and doesn't combine
I have a report of a combination of 2 sheets. Everytihng is the same but they both have one column called "Event Sub-Type" and for whatever reason, the report shows 2 "Event Sub-Type" columns (it doesn't do this with any other duplicate columns, which is extra weird.) Instead, both columns are next to one another andโฆ
-
connection between outlook and grid
HI, one of my statistic is how many please is present and out of office. This need to be change by employee manually. Is it possible for smartsheet to checking if someone is available and automatically fill status? Thank you
-
Totals from report or sheet summary for dashboard
Hi I have been able to create a sheet summary report and standard report from my sheets - aprox 10 sheets. I want to put a single $ from all the sheet totals into one figure on the dashboard. I can only get the reports to provide individual sheet totals. How do I sum a Grand total from a report? Thanks
-
Hi, My Cross Sheet formula =IF( is displaying the same results when I drag formula down dest column
Hi, When using the following cross sheet formula (see below) it appears to pull the data correctly from the source sheet (top pic) into the destination sheet (bottom pic), however when I drag the formula down it populates the same information - I'm using the Equipment Name as an example. As you can see in the source sheetโฆ
-
Countifs and exclude criteria
I am trying to count how many people are requesting computers only.ย I would like to exclude the people that are requesting a computer and internet. I have the formula for the total number computers requested =COUNTIFS(, {Computer Only}, "Computer") but not how to not count the ones that have internet.ย Can anyone help?