- Multiple linking
I'm looking to select a row based off of 2 criteria searched for in the row, and return a third value in the same row. I feel like this is possible with the existing functions but for the life of me I can't seem to figure it out. This wouldn't be difficult with array equations in excel but i'm not having any luck…
- Sheet Summary
I have a sheet that I created as a log essentially. What I'm wanting to do is create a "report" that summarizes the data. As an example, I want to report total records, smallest number, largest number, and count of records with a specific condition. How would I go about doing this?
- Date checkbox formula
Hello, I have a column of dates which are showing when an item expires. I want to have a column with a checkbox and a formula in it that will tick if the test date less 365 days is within the current month of todays date. So basically the test date less 365 days, and then checking if that date is within the current month…
- Formula help
I'm trying to create a single sheet that has multiple audits from 4 facilities. I am finding problems in trying to have smartsheet count the amount of cycles in the audit. The information is being input through the web forms so new rows are being created constantly, and the information needs to run through the sort filter…
- 帮助-公式等于如果/那么
Final Decision (WEBFORM) is a hidden column with the webform results in Yes, No, Hold symbols I need a combination formula for "Final Decision" column: 1. To equal the results in "Final Decision WEBFORM" column 2. AND IF "Final Approval" Column is checked, then show "Yes"
- DEPENDENCIES FORMULA IN TO A PROJET SHEET
HELLO; I HOPE YOU CAN HELP ME WITH THIS PROBLEM: I NEED TO SCRATCH A FORMULA TO GENERATE DEPENDENCIES AUTOMATICALLY IN A PROJECT SHEET WITH THOUSANDS OF ROWS. EACH ROW CORRESPONDS TO A TASK REPEATED RANDOMLY. AND MY PROJECT HAS MORE THAN 70 DIFFERENT TASKS, SO IT IS VERY LABORIOUS TO ASSIGN DEPENDENCIES USING FILTERS BY…
- Price Book Entry Import
Dear colleagues, I am seeking for advice on the following challenge. I am using Smartsheet to update and insert Salesforce Price Book Entries. Inserting a new entry requires Price Book ID and Product ID. If I map these fields, they are imported from SFDC and won't sync to a new entry record. Similarly, if I create new…
- Different columns with the same name ?
How can i make several columns with one same name???
- FORMULA - Estimated vs Actual Time
FORMULA HELP NEEDED (See Screenshot) I need help creating a formula to show: IF "Actual Time" Column is 10% more than "Estimated Time" Column, then "ERP vs ACTUAL" Column shows "DOWN" Symbol IF Not, shows "UP" Symbol. Times are entered in minutes (00.00) Thanks in advance! This is what I currently have: =IF(AND([Actual…
- Comparing Actual Duration to a Projected Duration with a +/- days
Three columns used are Duration(dependent), Projected Duration(I initially copy all of the durations over when setting the project) and +/- days(calculates the difference between Duration and Projected Duration) The trick here is you need to strip the "d" from the value to allow computations. =(VALUE(LEFT([Projected…
