-
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.
-
Dynamic View not showing the values of a formula column that is a Read-only in the data options.
When trying to add a new item on dynamic view after i have picked my question category it should return a specific question on the next line (with no changing option, read-only). It does not show my specific question, after i hit save for the new entry it does show. But the problem is that i need the submitter to see the…
-
Formula to check box on header row if any rows nested under it have a specific owner/assigned to
Hello, I am trying to work out if the following scenario is possible. I have a bunch of parent tasks / child tasks. I have these child tasks feeding into a report/dashboard IF the assigned to is "Client" and want to include the headers where appropriate (ex. I don't want to pull through ALL the header rows on the sheet if…
-
Formula to pair staff based on criteria
Hello Smartsheet community, An idea came up recently about pairing staff up who work in different divisions for a random coffee chat to increase staff engagement. We could use Smartsheet to create a form to gather info on staff who are interested in participating and what division they belong in but is there a formula I…
