-
Formula that will track the total number of jobs on the sheet at the end of each month
Hello, I am looking to create a formula that will track the total number of jobs (populated rows) in the sheet at the end of each month. The data outputted based on the formula will be displayed on a line graph widget in order to track the progress of the company by each month. For example, if there are 115 lines at the…
-
Ability to Find & Replace text in Formulas
Hi Team, I am aware that this functionality isn't currently available. But, as someone who works on rows & rows of data every day, replacing values in a formula using the Find & Replace feature is extremely helpful and time-saving. As I type this, I have the daunting task of going back to my sheet on SmartSheets and…
-
Percent for activities 100% completed and for ongoing activities and for not started activities
Can anyone please help me with this How i can get a percent of the activities that are 100% completed, and a percent of the activities that are ongoing and for the not yet started activities. the total of three figures is 100% of the project. I hope that I explained it correctly, and thank you in advance.
-
Using COUNTIFS with CONTAINS as a Criterion
I have a multi select list column in Sheet 1, containing campuses. In sheet two I am trying to get a count of how many times each campus is listed in the campus column in sheet 1. Here is my current formula: =COUNTIFS({Event Campus}, CONTAINS("Cypress", {Event Campus})) The results are always "0" for each campus. Given…
-
Median with criteria
Hello! I am trying to get the median days to complete for anything that is Bank of America, Chase Bank, etc. etc.. I have tried using the entire column in the formula and also specifying the specific cells and both returned with errors. The formulas I have used are the following: =MEDIAN(COLLECT({Days to Complete},…
-
How to use a smartsheet to update the form dropdown values in another smartsheet?
I have a smartsheet that contains employee names and employee IDs. I would like to use the employee names stored in this sheet to update a form dropdown list of employee names on a separate smartsheet that tracks employee activity. I was going to use data shuttle, however there is not an upload data from a smartsheet…
-
Having automated backups (such as weekly) the formulas also included
Having automated backups (such as weekly) the formulas also included. It would be so good!
-
Text to Rows--Possible?
Hello, I've been all over the community forum and looking at various brilliant solutions, but can't seem to figure out how to do what I need. I have a form that has a field (Information) for a list of Number and Date entries. Instructions tell users to use a semicolon as a delimiter. I need to parse them into separate rows…
-
Formula Help: Choosing Most Recent Fields Across Sheets
I’m working with two Smartsheet sheets: Sheet A: Tracks courses taught (each row has 2 instructors + 2 courses — both instructors taught both courses). Sheet B: Lists instructors. I want to display the most recent course(s) they taught, pulled from Sheet A. My challenge: Because Sheet A has two instructor ID columns…
-
Check Box for Current Milestone
I am looking for help in writing a formula (or using automations) so that the most recent milestone where the status is "INV PKT SENT & PSR XL UPDT" will have the checkbox. As you can see, I can write a formula to check the box but then when the next milestone reaches that same status I now have multiple checkboxes in the…