-
IF FORMULA AND 2 DATE COLUMNS
Hello, I am wanting to capture a date into a current date column if there is a date in the second column. Example: If NEW EXP DATE has a new date, I would like that date to display in the CURRENT EXP DATE column. If there is not a date in the NEW EXP DATE column, then I would like to keep the current date in the CURRENT…
-
I have reached the maximum number of Cross References, is there a way to Index Match an Entire row?
I am working on across a couple sheets where the columns contain all the same info across 7-8 sheets and the individual sheets correspond to different groups of people. I am trying to consolidate all of the info into one sheet that updates with changes to the 7-8 reference sheets. I have been doing index matching for each…
-
Date incrementing column formula works fine except in two cases.
Hi there, I am using a formula to establish future dates (Scheduled Pull-Out Date) based on a starting date (Packaging Date) and adding a number of months according to the 'Time Point' column. The formula seems to work fine until I noticed that two entries (in purple) are not following the rule; they are supposed to add 9…
-
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!