-
Using the ,21 (ISO) option when determining WEEKNUMBER - Sheet displays ok, Report doesn't
Hi, When using this formula to return a week number =IF([Date completed]@row = "", "", WEEKNUMBER([Date completed]@row, 21)) the correct week number value displays accurately in the sheet which is good. However, the Report fails to display the column value and displays #INCORRECT ARGUMENT SET Removing the ,21 parameter and…
-
Sheet Overview/Screenshot in Dashboards
Hello, I'd like to create a dashboard for my team where we can see information from multiple sheets at once. These are normal grid sheets, not reports. Is there a way to do this using the dashboard feature? Appreciate any guidance. Thank you, McKenna
-
Connect sheets without manual cell linking
I have a project roadmap (activity name, start date, end date, etc) and then a separate sheet where we want to pull from the existing project roadmap. With roadmaps, information is always changing or being added and I want the separate sheet to be able to live update when changes are made. I don't think an automated…
-
Why are charts appearing very pixilated and low quality?
Using latest version of Chrome, just updated it and cleared cookies/cache then restarted my computer. This has never happened before not sure what is causing it: I am zoomed in 100%, even at 50% or 150% the problem is the same.
-
Find the row with the earliest Created (Entered) date that matches certain criteria
This one was a challenge. I thought I had it solved, but an erroneous value showed up, necessitating taking the formula back to the drawing board. The requirement: Show me the oldest Bill of Lading number that does not have a status of "Closed" or "Canceled." In another cell, show me the full Created date and time of that…
-
3 condition formula- Help
Need help with a formula, 3 conditions- 1) Recognize first 3 digits of "ticket number" (EX: "LEG", "ONB", "REV") 2) Recognize when a task is past due 3) Status not "Complete" or "Not Applicable" What I have so far: =COUNTIFS({KIM- Project Plan- TEST Range 3}, "LEG", {KIM- Project Plan- TEST Range 1}, >TODAY(), {KIM-…
-
Delete and Lock row
Dear All I would like to know. Is it possible, if I want my team can edit the row but they can't delete it?
-
Multiply cell by 2 if checkbox is checked
Hey Smartsheet users! I've read through a lot of check and IF formulas and haven't been able to find my answer so here is the situation. This is for a mileage reimbursement form. I have a column titled "Mileage" and another column titled "roundtrip" the Roundtrip column is a checkbox column. See picture for what I'm trying…
-
Need help with formula to automatically fill in Contact List from another column
Hello, I have the following columns and sheets and I just cannot seem to figure out how to do what I need. Sheet 1 (Main Sheet) Staff Listing (value is Text Full Name coming in from outside source) All Staff (Contact List selector (assigned to)) Sheet 2 (reference Sheet) Technician Name - Contains full name Email Address -…
-
Creating a chart from non numeric values
I have created a form for users to fill out based on their experiences with a certain process. They will be asked questions such as "were instructions clear" and they can answer Very Clear, Somewhat Clear, Unclear. I was trying to create a pie chart from this sheet that shows how many users selected Very Clear vs. Somewhat…