-
Function vs Project Structure
I am a contractor with many projects and I am trying to determine if it is most beneficial to have the individual projects have their own sheet with various silos of activities (in-field construction activities, office deliverables, accounting processes, etc.) and run a report for each team member/silo of responsibility. I…
-
Is there a formula or function that allows text to be removed and replaced elsewhere on the Sheet?
Hard to explain just in the question box. We have a staffing schedule for our company which allows us to see who is currently on jobs and who is coming up for availability for an upcoming job. We are trying to figure out if there is a type of formula or function that would allow us to type an employees name in next to the…
-
Return Column Names AND values from row in a reference column
I'm trying to figure out how to return the columns and values found in them for any given row. I have approximately 200 unique columns that are populated from a web form if/when the column is relevant. individual rows track construction items completed. Each row identifies crew, date, job number, etc., and the remaining…
-
INDEX/MATCH function doesn't return exact match.
I'm having and issue with the MATCH function not returning an exact match. If my understanding of the formula is correct: "1" for the [search_type] should find the first value greater than or equal to the search_value starting from left to right, or top to bottom. "-1" should find the first value less than or equal to the…
-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
-
Kanban View - printing or saving to PDF
In the Kanban sheet, can this be saved to PDF in card view or printed in card view ? currently it shifts to list view when printing.
-
Start and end date line chart
Hi Team, Can anyone help me how can I create a line chart based on below information. I
-
If and Find
If cell A3 contains "ABC" then enter "ABC" in cell A1. Can someone help me do this in smartsheet? I tried using =If(find("ABC",A3,)="ABC","ABC","X") but its not working. Thank you
-
Update Columns in Existing Row Using Forms
Hello, I have a sheet where I am tracking construction progress. There are a lot of data/calculations that my field personnel do not need. I want a simple interface for them to update data (% Complete, Actual Date Completed, etc.) Each row is auto-numbered for tracking. Is there a method for a form or process to create…
-
Dependency Logic based on one or the other predecessor tasks
Is is possible to create schedule logic where a dependent task is dependent on one of two predecessors (either or not both)? For Example: I am trying to build out a schedule template for if a permit is required vs not for a specific project. IF a permit is required then the rest of the schedule should be based on the…
