-
#NOMATCH Error in VLOOHUP when values are an exact match
I have two sheets: Change Oorders and Change Order Pricing. IN Change Orders, there is a column called Task1 which is a dropdown menu. The values in the drop down were copied and pasted from Change Order Pricing, "Task" column which is the first column. I created this formula: =VLOOKUP([Task1]@row, {Change Order Pricing…
-
Formula With a date
I am having an issue with creating a formula that will count a column if a row has a date in it. It can be any date just as long as it has a date. PgM Status is the column with the date right now I'm just counting the section that has the dates but would like to create a formula, so I don't have to keep adjusting in the…
-
T-shirt size icons for visual icons?
Would love to have S/M/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum team
-
Adding Task Name to Right Side of Bars
I have an existing sheet that used from a template. It was imported from Project. There are currently no task names beside the bars in the Gantt chart. Is there a way to add the task name to show up to the right of the bars in the Gantt view?
-
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…
