-
Comment calculer la somme d'une sélection dans une cellule à sélections multiples?
Bonjour, J'essaie de trouver la formule pour calculer uniquement une sélection à l'intérieur d'une cellule qui comprend plusieurs sélections. Exemple: dans une cellule, il y a 3 sélections : bleu, jaune et rouge. Sur une colonne de 25 lignes, je veux savoir combien de "bleu" a été sélectionnés? Merci de m'aider!
-
Update Request - Shows Sending, but Not Received
Hey all - Been using all the great functionality of SS for quite some time now. I have an Automated rule setup so that when a person Submits a certain thing, an Update Request is Automatically triggered. I've had several of our AEs reach out saying they're no longer receiving them, but when I go into SS, I can see that the…
-
Did the 'View cell history' get removed from collaborators?
I seen a community session where some license users said the 'view cell history' function was being taken away back in 2019 but then the last message noted said the decision was reverted and the function was going to continue to work on all permission levels. A vendor just emailed me asking me to provide them the cell…
-
Make on weekend as working days
I need to make one weekend as working days in my project. I don't want to create a parent task with sub tasks. I want to force the weekend to be a working days. I appreciate your help
-
Checkbox & Pulling back values in a cell
Hi, I've done my research and it looks like people have had to use Zapier for this specific use, but want to throw it out there again before i go that route! I am looking to pull back a value from a row where a box was checked. So i am thinking that in my formula sheet i can create a formula that basically says 'if the box…
-
Subtask Summary not Updating in Card View?
In Card View, my Subtask checkboxes do not tally at the bottom of the card (Full View, closed card). This is a new development. Any thoughts to help? Thanks!
-
Date updating to Next Day using Index, Match, Max, Collect Formula
Hi, I'm working with two Smartsheets. (1) One sheet collects the data from a Smartsheet form. I added two columns to this sheet using the Auto-Number/System Feature (under Edit Column Properties). This features stamps new row entries with a date/time (Created) and by whom (Created By). I'm curious about the cell surrounded…
-
Create cell reference based upon horizontal axis position
Is there a way to create a cell reference based upon a horizontal axis? For example, for a given column, I want it to always represent the cell directly to its left. For this example scenario, a new column will be added for every date and the new results will be entered into that column - Since the new date column will…
-
Developing existing formula
Hi, I have a formula set up to basically check if an action is open. Currently the formula is as follows: =IF(OR([Post AFC Change Status]7 = "1. Received", [Post AFC Change Status]7 = "7. Withdrawn", [Post AFC Change Status]7 = "2. QA Rejected", [Post AFC Change Status]7 = "6. Returned by NR PM", ISBLANK([Post AFC Change…
-
How do I return the name of the month in one cell if I only have a date (xx/xx/xx) in another cell?
I'm attempting to track the number of requests received and the months they were requested. What formula can return a Month name for a date (xx/xx/xx) e.g if I have 12/25/19 the formula will return December 2019. Please assist. Thanks
