-
Formula to obtain upcoming deadline
Hello! I am working on getting a widget on a dashboard to show the next upcoming deadline, automatically pulling this information from the below sheet, analyzing the 3 date columns. I've tried several COLLECT formulas but nothing seem to work. Any ideas?
-
Autofill Form
So if I have a purchase request form I want to select Item A, for example Once I select that, I want it to give me than a list of budget numbers to pull it out of (Item A for engineering, Item A for software, etc.) Then autofill with a set price, and I put how many I need and/or show me how many are currently budgeted for…
-
Update request for cells with cell formula
Hi Smartsheet Community, I'm trying to automate an update request for a daily form submission. The data are entered to the source sheet from the form and I've used cross-sheet formulas to pull the data in the the format needed for the document builder sheet. However, when I run a test Update Request for empty fields in the…
-
Stumped!
Trying to calculate a % for where a particular column is filled in. We have various blanks (lining up with headings) that I need to involve in the calculation. Here's my formula: =ROUND((COUNTIF([Common Control - Client Comments]:[Common Control - Client Comments],<>"")-COUNTIF([Ctrl odr]:[Ctrl odr],""))/COUNTIF([Ctrl…
-
Check a box if MOST RECENTLY MODIFIED, per Hotel
Pulling my hair out! Need to check the box of the row with the most-recently-modified entry, per hotel. Not the best data set for an example but below is a screenshot of my grid. Using this formula but getting INVALID results. =IF(AND(Hotel@row = Hotel@row, Modified:Modified = MAX(Modified@row)), 1, 0) Anyone? Anyone? :)
-
Is there a way to optimize drop down menus?
hello i am trying to have certain values only show when someone chooses one value. here's an example: Entity 1 Entity 2 Entity 3 Now based on those three entity there would be a seperate drop down menu with 10 items: Item 1 item 2 item 3 item 4 Ext... But if i choose entity 1 then only item 2 and 7 show but if i choose…
-
Need help with a SUM/LEFT formula
I need a formula that will add the 1st number in different cells in a row. So in the below picture, there will be different numbers in these cells, with text behind it. At the end of the row I would like to add all these numbers together and get an overall score. Here is the SUM formula I have, just need to know how to…
-
SUMIFS & CONTAINS formula
Hi, I'm trying to identify the # of request types by a specific job title. The source of the data is on another sheet. The formulas I have tried so far have been producing zero as a result (which I know is incorrect based on the source data). =SUMIFS({Request Type}, {Request Type}, ="Initiative / Project", {BranchJF},…
-
Help to Sort by number and words
currently we have a built in prioritization score based on the data entered on the intake form This will populate either a score of 1-5 OR the word "Tech" When filtering these through the report on our dashboard we want to sort in descending order but want those with the word "Tech" to populate last instead of first I am…
-
How can I sum all the values of a column of "hours"?
hi everyone, I'd a issue with "time sum" that i need to converting to decimal after sum as you can see in the picture below. Is possible do a time sum without converting to decimal? @Paul Newcome do u mind help me with this quest? i really appreciate any help.
