-
Week Ending Date
Hello, I am creating a Safety Audit Database. Similar to Scheduling principles, we keep track of all data entries by two dates. ACTUAL DATE and WEEK ENDING DATE (where Week Ending date is Sunday) We use a formula in Excel to do this but I am not able to replicate such formula in smartsheet. Does anyone know how to do this?…
-
Data Matrix for dashboard - cross sheet formulas
I have created extensive data matrix's to calculate # of Jobs and dollar amount for individuals in our company to track capacity. However, as our sheets get larger, the formulas wont calculate. I receive an error message reading: "Some cross-sheet formulas cant be updated, because this sheet has more cells referenced from…
-
Return Text based on a date
I am trying to write a formula that will return the text "Current" or Expired in the INS status Column based on whether the dates in the GL, AUTO and WC dates are past today's date. Hitting a wall. Attached snip of the sheet Thank you in advance for any help!
-
I Need a Construction Daily Report Template
I am a construction project manager and I am new to Smartsheet and I'm trying to create a Daily Report template. I can search the web for Smartsheet Daily Reports and I find several "templates", which all say "Smartsheet" on them, but they are microsoft excel files. When I try to import them into Smartsheet, they never…
-
Counting total based on Status & Date
Hi, I'm trying to calculate the total value of all the won job in this financial year. I have to reference 3 columns for this (Date submitted, Value, Status) not sure how to make the formula. This is as far as I got. Please help. =SUMIFS([Tender Due]:[Tender Due], >DATE(2018, 6, 30), <DATE(2018, 6, 30), Status:Status,…
-
Lookup two columns in the same sheet and return unique values and counts
I have a sheet where issues are logged. The primary is a record ID, I have another column "Assigned" which has 7 names in a dropdown. Another column is "Field" with 9 options in a dropdown. I am trying to create a formula that will lookup unique pairs from Assigned and Filed and count the number of records for that…
-
How to have child rows displayed using parent data
Hi all, I have a complex sheet which is efectively a "to do" list. Thanks to the community I have it working pretty well as I want and am very happy with it. To polish the sheet, I would like to achieve the following: I have my todo's organised by project then category. For example, I have a column called "project" which…
-
Auto move column info
I'll try to explain the best I can. I have a customer who will view only a summary sheet in Smartsheet. This info is pulling from various cells in individual Smartsheet store pages that they cannot see. This summary is set up in a "One store per Column" arrangement. As the store page info is populated, various info…
-
Weekly Tracking for a Dashboard
I have a grid where I am trying to lookup from a grid that people can log issues on. The first lookup is the date range, we want to count all issues within that date range. Then we only want to count by the "Field". On the log it is the column titled Field it is a dropdown of those fields listed on the Weekly trend grid as…
-
Sheet automatically scrolling across as soon as I place mouse in sheet.
I have one sheet (that is shared) that automatically scrolls across to the right of the screen as soon as I place my mouse in it. I can not manually correct it back to centre or to the left of teh screen so i can read the data in it. My other sheets are not affected, and are working fine. Can you please recomend a remiedy.