-
COUNTIF Question
Is there a formula that allows me to count the number of cells within a range that contain a certain string of text, where the cells in the range also contain other text?
-
Email import via Zapier
Hi I am auto-forwarding certain emails from Outlook to a Smartsheet list via Zapier. Everything comes across fine but certain data fields seem limited in space. The body of the email doesn't fully transfer. It seems there is a character limit to either the Zapier forward or to Smartsheet. How can I get the complete email…
-
Move row - selected columns only?
Hi, We manage Intake to Archive in Smartsheet. Our Intake Sheet (source sheet), where we collect all project info, is rather lengthy. When an Intake Request has been approved, I want the row to be moved to an Implementation Sheet (destination sheet). The destination has different columns that the source sheet, only a few…
-
Formula cross referencing sheet via template
Hello! I have a workflow created using Zapier so that when a new row is added to my master project sheet via a form entry it will update the first row in a template sheet and create a new project sheet from that sample sheet. This all works great with the exception I have one formula that uses a vlookup to tell the status…
-
NEW updates to our community!
Last week you may have noticed some updates to our current community! While a number of these updates were visual updates around the look, feel, and navigation of the site, there were also a few functionality updates we wanted to share with you as well: My communities and my groups- when logged in you will now see a list…
-
CAPA - Industry Standards (benchmarking)
I am in the Medical Device industry. I am looking for some bench marking information around what a well rounded CAPA system Metric should look like. For example: What is the typical percentage of CAPA types in your CAPA System. For example: Random numbers here: 78% Corrective 14% Preventive 7% Internal Audit Corrections 0%…
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
Multiple selection on a drop down list
Hi, I read in another tread that the ability to select multiple items in a dropdown list was in development. Does anyone know if that is available now?
-
FORMULA NOT WORKING
HI, I have a formula =IF(E3>0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE can anyone help fix this issue?? Please see attached excel with formula in Column D Thank you in advance :)
