-
Auto Populating A Column
We are using a smartsheet to track fleet vehicles. We have created a form that employees use to reserve a vehicle. Within this form the employee selects the location of the vehicle they want to reserve, which is a drop down of cities with our vehicles in them. When they select the city, we have set up logic to make their…
-
Why are the columns for my sheets not populating on report?
I have created a report with parent rows and tasks. with columns of data however when I try to create a report and choose the columns either not all columns are offered to select or when I do select them, they do not populate results. Why would this happen.
-
Summing data across multiple monthly columns and sheets where criteria is met.
I am trying to get a total for each location across multiple sheets. Each sheet has a location column and Aug-24 to Dec-26 (one column per month). So, location of employees with their work hours in rows in the monthly columns. I'm trying to get the total hours per location on a separate metric sheet. So start with:…
-
Need to do a contains collect collaboration but unsure if possible
Basically I have two sheets and am trying to get information from sheet A into sheet B In sheet A, I have two columns. Column one contains number e.g. "123 456 789" and column two tells me if the row is approved, pending, or unapproved. In sheet B I need to know what column two is saying in the row where column one…
-
I need help with formulas!
Hello, I am trying to create a dashboard for our staffing office and trying to create a visualization of how many of each discipline (RN, MHW) are assigned to each shift. I have a separate Metrics sheet where I have the total for each shift and the total for each Discipline; however, I cannot figure out the formula to…
-
Form Approver sees field name, not label
I have a form filled out and approved by two parties not associated with smartsheets. Testing the application, i noticed that the approver doesn't get to see the same form as the person who filled it out. They see a different form. The main difference is the field names. The approver sees the name from the smartsheet…
-
Need help with % complete based on duration without using dependencies
I have a sheet that I do not want to use dependencies on, so I can cell link dates. That being said I want to calculate duration and % complete based off that duration for parent rows My duration equation is: =NETWORKDAYS([Start Date]@row, [End Date]@row) But I cannot figure out how to calculate % complete so that the…
-
Convert to Column Formula - column formula syntax isn't quite right
I am trying to populate project number from line 1 into line that has any text in To-Do column. The single line works but when I try to convert column formula I get "The column formula syntax isn't quite right, see our help article I have tried it both =IF(ISBLANK([To-Do]@row), "", [Project Number]$1)…
-
RESOLVED: AVG(Collect) Formula Returning #InvalidDataType
Hello, First, thank you to all the formula gurus who lend your time to help us with our broken formulas! My Task: calculate average response time per fiscal year. The Formula Used: =AVG(COLLECT([Response Time]:[Response Time], [Allotted Plan Review Time]:[Allotted Plan Review Time], "30", [Fiscal Year]:[Fiscal Year],…
-
Renamed primary column on one of my report to match another, now my combined report does not work
I renamed the primary column one of my smartsheet report to match another smartsheet so that I can combine the 2 reports together. Now my combined report does not recognize one of the reports and it states "Column not found" How do I correct this?
