-
Automatically back dating based upon future date
Hello, I would like to update a sheet by putting a date in one field and having serveral date feild updated based upon the first feild. Now I think that I can do [date] + 15 or [field] + 15 but can't figure out how to set a date and work back 1,2,3, etc weeks from that date. [Field] - 7 day does not appear to work.…
-
Finding text between two parenthesis
I am trying to pull the text between two parenthesis and place in another field. In the screen shot attached I am wanting to get the data between the two parenthesis in the "Requested by (NetID) field and place it in the "Requested by NetID"). In other words, I want "dj32" to be in the second field. Anyone have any ideas…
-
Timesheets
My firm uses Smartsheet for timesheets and client billing. There are now 22 people filling in individual timesheets. There is a Client Name column with a dropdown box with all the client names, probably about 100 now. Monthly, I manually go into all 22 timesheets and update that dropdown box with new client names. This…
-
% Calculations On children
HI Community I have A Quick Question On % Calculations I have a Payment Sechdule Which has a a main Name For example Wall Framing Under Wall Framing i have indent Wall framing on Floor 1, Floor 2 etc, And i ran =SUM(CHILDREN()) To calculate Total We charge on Wall framing Now For my customer i want to send only The Main…
-
Counting rows with multiple drop-down options
Hello, I would like to count all the rows on a sheet that meets certain criteria. The sheet has a column [Project Status] with the following drop down items: Tentative Confirmed In Process Delayed On Hold Punch List Completed Cancelled RMA Processing I would like to get a total count of all the rows that have open…
-
Find the Max and Min value in a column
Hi, I have a sheet with a single column that has a large range of numbers. I would like to use conditional formatting to highlight the highest number and the lowest number within this column so its easy to see when viewing the sheet. I can use the functions Max() and Min() to find the highest and lowest values, but these…
-
LOOKUP function - I cannot find any info on how it is supposed to work
Hi, I have read some threads but I am still not clear on how LOOKUP is supposed to work. I know it cannot function across sheets. But please can someone provide the syntax and basic data? Thanks, Ele
-
Compare text in two different columns
I have a large SS that includes two rows of columns...one is the listing of the latest print revision, and I want to compare it to another column reporting which revision the part was actually built to. Both of these columns are populated with a letter (NC, A, B....AZ). My goal is a Conditional format color if the two…
-
Triggering a notification based on the dates of two rows
I would like to create a notification to let me know a task will be finishing late, which will impact the start of another. IF the 'Finish Date' of task 'Narrative' is greater than the "Start Date' of task 'Review' send notification You can see in the screen shot that Hillary is going to be impacted on starting her work…
-
How do I count new rows from web forms?
Hello, I'm trying to count new rows that come in on a web form below a specific row using a formula. How do I start my formula range on a specific row, then count all new rows that are below it as they come in from the webform? We use a webform to receive quotes from subcontractors. As they come in, they are moved up to be…