-
How to count different text values listed in a column
I have 2 columns/ranges. I need to count if range1 is value text1 and range2 has values text2, and text3, and text4. This formula works so far =COUNTIFS([Range1]:[Range1], "Text1", [Range2]:[Range2], "Text2") However things get wonky when I wan to add more text values to Range 2. So it would kinda look like below. But…
-
Payment topic and change the administration
Hello as of today, we didn't enter to our Smartsheet account because of unsuccessful Payment depens on old card Our credit card which is saved on system before, timing was over. new card was sent later. but we have fotgotten to change this card number on system. Now we have problem. our payments were done by person1…
-
Critical Path not working
I cannot get the critical path to work for my entire project. I have 519 lines in my project plan and it's only showing the last 20 or so as critical path. I have predecessors, and dependencies enabled. Help!
-
Remove "Fill out forms with a Smartsheet App"
Hello Everyone. is there a way to remove this message and download links from the top of forms? This occurs when I create a form for users who do not have a Smartsheet account. We use a QR code to display the form link. When the user scans the QR code with an IOS device, the form comes up with "Fill out forms with a…
-
Automation Alert format - Grid vs single email
I have two automation paths set up. Each of them is basically identical, except for one condition. (That is, if [field] = 'M', do automation #1. If it's 'N' , do automation #2.) When automation #1 runs, the results are returned in a single email as a grid. (exhibit A) When automation #2 runs, the results are returned in…
-
Is there anyway to @ a group distro email?
Does anyone have any workaround for tagging a group distro Gmail in the comments of a sheet? If I tag each email in the distribution then they will all be notified however just tagging the distribution email does not notify anyone. Any ideas are appreciated as this would be very helpful!
-
Open Smartsheet Notification Links in Desktop App on Mac with MS Edge
I used to be able to do this while using chrome with the chrome extension but I can't seem to find an extension for MS Edge (chromium) to open notification URL's in the smartsheet desktop app. Is there a way to open smartsheet notification URL's in the desktop app?
-
Sheet Summary on a Report, Displayed on Dashboard
Hey Smartsheet Community, I am trying to display a sheet summary from a report on my dashboard. Any Suggestions? I don't want to show the entire report, just the summary line. Thanks in advance for your time and help. Erin
-
iPad Bold Type, on and off?
I notice, if opening a file on a PC, if the last typeset was Bold Type, when you open the Sheet on an iPad, your type will be in Bold. Where in the iPad app, can you switch your type to and from Bold, Italics, or Underscored?
-
How to organize multimedia folk dance data in Smartsheet effectively?
I'm working on a project to catalog 100 instances of a folk dance, including various elements like video, PDFs, text, images, categories, steps, etc. I am looking for advice on how to efficiently structure a Smartsheet to handle this type of multimedia and categorization. Could anyone suggest the best approach to start…