-
Cell Linking returning wrong values
I have cell linking from multiple sheets, some of the links return a value than what is linked. Ex: On the sheet I am linking the value shows -34% but the sheet with the linked cell was returning -87%. The only way to correct this is by removing the link, deleting the value in the sheet, selecting save, and re-linking. The…
-
Copy data from secondary sheets to primary sheet
We are setting up a project approval process. We have a primary “Intake” sheet where initial project data is entered. In many cases, users will be providing project budget and resource information later. We do not want them entering data directly on the sheet so would like to use supplemental forms using a project ID as…
-
Approval Workflow and SUMIF Formula
Hi, I have a form individuals submit when they request tickets for an event. Our sheet manager can either approve or decline the requests. If approved, I have a formula set up that removes the amount of requested tickets from the total. The request entry is copied to a separate sheet that has a calendar of each event along…
-
Nesting IF Statements to provide % Complete
Hello All, I have a project sheet with the following status dropdown: Not Started In Progress Ready for Review Complete Canceled On Hold Not Applicable I'd like to write a nested IF statement to provide a value in a percent complete column. I've tried the following but get a #UNPARSEABLE response. =IF(Status@row = "Not…
-
Help with creating Formula's using " Is Blank" and "If"
So, for the first part of the equation, I wanna say " if the contract end date is blank, then the decision date cell will be blank" and the second part of the equation is the decision date column = (Contract End date minus Notice Period) =IF(ISBLANK(Contract End Date@row),COUNTIF([Contract End Date]@row - [Renewal Alert…
-
How To Sort by Report Sum
Hi There! I have a report: https://app.smartsheet.com/b/publish?EQBCT=892ee58c40f64b28b1128f4216f43dae that I've built from about 40 sheets...Meeting Trackers. We track across all our workgroups who attends and how many meetings they attend. This report by Attendee Name (Primary), sums the total number of meetings they've…
-
If formula return date
I'm trying to make a check on a cell and once it goes to a particular value "Committed" I want create a time stamp of the current date in another cell on that same row. Seems simple enough, except for me :). Here is what I tried to put in place: =IF([Stage]="Committed", DATEONLY(), ) Maybe I don't understand the DATEONLY…
-
Using the average and standard dev formula
I am trying to use an average formula to get the average of data from the past 30 days. I tried using collect but seem not to be working as it gives me an error. I also am using standard dev formula both for the past 30 days/data before that row. Please help.
-
COUNTIFS help for future dates
I wanted to create summary tasks for items that are past due and then items that are upcoming in the next 30 days. My Past Due formula is working correctly: =COUNTIFS([End Date]:[End Date], <TODAY(), [% Complete]:[% Complete], <0.1) My Upcoming tasks formula is not: =COUNTIFS([Start Date]:[Start Date], <=TODAY(+30), [%…
-
Workflow for Tracking Inventory Counts and Bin Locations
Hi, I am trying to setup a sheet to keep track of when we count bin locations in our warehouse and how often. I would like every bin to be counted at least once ever 12 weeks. In our bin locations column, I have a multi-checkbox setup with all 403 of our bin locations in it. We typically count 5-12 bins a day. Can I setup…
