-
Formula Help
Hello, Can someone see what im doing wrong with this formula please? =IF([Q1: Navigation around site and accessing document]@row = "Not Applicable", 0, (IF([Q1: Question 1 ]@row = "Did not meet expectations", 1, (IF([Q1: Question 1]@row = "Partially met expectations", 2, (IF([Q1: Question 1]@row = "Met expectations",…
-
Formula combining COUNT,DISTINCT & CONTAINS
Hello SS Community, Can you guide me on a formula to deal with the above data set? In plain english, I need a Count of Distinct strings in the 'Release Set No." column Containing "Annual" The answer in this case would be 8. Is this possible on SS? Thanks for your help!
-
Cell reference keeps loading on Vivaldi
I am using Vivaldi as my main browser and recently become unable to read cell reference from the below context menu. The pop-up screen shows up but it is loading forever. I have tried to re-login, cleared all the cache on browser, disabled all the ad-trackers, but no impact on this issue. I have tested the same in Edge and…
-
IFS function with AND
Dear community, Does anyone knows how to create a formula using IFS? Smartsheet doesn't seem to have IFS. The formula I would like to create on my sheet: =IFS(AND(ISBLANK(B3),ISBLANK(H3)),"",D3="Decision","NA",AND(B3<>"",ISBLANK(H3)),"Open",AND(B3<>"",H3<>""),"Closed")) Thanks in advance. Fernanda
-
Formula for SumIF
I need the formula for the following Sum of ($ value column, in another sheet), if value of another column = jan (which is a date column in same sheet as the value) This will forumla will be in another sheet.
-
Can you pull between two times when using the countifs function?
When using the Countifs function, can you reference the created column (which includes both the date and the time) and pull based on submissions between certain times. EX: =countifs({Form Date}, TODAY() - 1, {Form Date}, "04:30pm:11:59pm")
-
Sum of texts in several columns
E possibile sommare in una colonna più testi di più colonne di un altro foglio cosa che faccio regolarmente all'interno di un unico foglio Translated by a moderator It is possible to add in one column several texts from several columns of another sheet - which I do regularly within a single sheet
-
what is the suitable function
I have 2 sheets, the first one is a table that shows the following and I have another sheet all what i need when i write the values in the first and the second column the data in the third columns appear what suitable function could be used
-
I moved a Reference sheet...Formula
Hello, I moved a reference sheet. I updated the new reference sheet in my formula but it doesn't update. I updated the "reference sheet" then since it wasn't updating I rewrote the formula. Still the same: I get the message: #incorrect Argument. Below is the formula: =VLOOKUP([Last Name]@row, {Employee Database Range 4},…
-
Is there a way to use ISBLANK to print out those rows that ARE blank ?
Okay, so basically I used =CHOOSECOLS(FILTER('Building Doors/Parking'!A2:D40,'Building Doors/Parking'!D2:D40=H1),1,2,3,4) with a dropdown menu, and i'm able to see loaded trailers, empties, return trailers, OOS ( out of service trailers ) etc... I'm only missing one piece to making this so helpful for my building. I need…
