-
Sum based on drop downs across multiple sheets
I have multiple sheets that all lead to a "Totals" sheet on the first sheet. This project is based on caseloads in a school system. Each "sheet" is its own school in the system. I have a drop-down on each sheet for the speech teacher for that school, as well as total hours of service time needed at each school/week. I need…
-
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…
-
Workflow Management
How do I automate the workflow from Person A doing task 1 to Person B doing task 2 and at the same time automate the measure of turnaround time and not being overridden by collaborators? Thanks
-
Make the rich text editor edit report cells on the dashboard
Greetings everyone, I was wondering if using the rich text widget to edit a cell in your report on the dashboard live is possible. The logic behind it is: The rich text editor is linked to the cell from a report and updates data simultaneously. Thus, I wouldn't need to go back and forth to the report and then to the…
-
Assign a last history of the cell into a column
Hello, I would need to track a lead time of request approval. I keep those approval status from several approvers of 2-4 people in the cells. I understand that there is a activity log report. however it still needs manual mapping to identify each approver timestamps and calculate time lag. My goal is assign a last activity…
-
Is it possible to get a weeks beginning/ending dates from weeknumber?
I have figured out a different set of formulas to get a beginning/ending date for a specific week and month. But have been asked if its possible to use the following: =countif(range, Weeknumber(@cell) = Weeknumber(Today()) to meet a date range criteria (something similar for month). I've tried the following with no…
-
Changing Colors of Gant Charts
Is it possible to change the colors of the main timeline bars (not just sub-timelines) on a Project sheet in Gantt view? I do not like the grey.
-
Row or Record roll up and multiple forms or sheets
I have been attempting set up a relational database for multiple client use. This database should track records (rows including child rows) as it progresses through different phases. Projects may stop periodically and should be searchable and may be re-started later. I have tried using 3 column relational connection to…
-
Best practice for an Employee on-boarding process
Hi - new to Smartsheet and my MD and HR Director have asked me to look at rationalising some Google Sheets they use at the moment to track employees from initial interest through to starting with the company. I've looked at a couple of templates and started down the road of creating a sheet which has Surname as the Primary…
-
Submitted Web Form - User Information
We are creating a web form to track business development possibilities. Other than adding a "Your Name" field to our web form, is there a way to see who submitted the form? On a current smartsheet where we are using a web form, I can right-click to view history, but it shows only "web form user". What we would like to see…