-
Formula to get averages from one column if another column is checked
Hi All! I have 2 date columns, Processing Start Date & Processing Turnaround Time, then a column to show the NETWORKDAYS, (labeled Average Setup Time), of those two columns. Then I have a checkbox column (labeled New Setup)and another column to convert the checks into 1, 2, 3, etc.(labeled Setups). What I need to do now is…
-
Software uses
Is there any construction companies out there that use Smartsheet other than for job tracking and HR? Maybe budgets and scheduling manpower? I need some ideas on how to set up those activities on smartsheet. Thanks!
-
COUNTIF Does not equal
Hello! I'd like to set up a formula to COUNTIF(Children)<>"app/registration complete" so I don't have to setup a more complicated COUNTIFS (I allow the dropdown to not be restricted to the text options I set up). Can't seem to get it to work. Is "does not equal" possible for COUNTIF in Smartsheet? Thanks in advance!
-
Tracking purchases
Trying to assist my purchasing department... I've set up a sheet for a department to enter their purchases, but my issue is that our purchasing dept wants to have it itemized. For example, I might have an Amazon order for $1000.00, but that $1000 is comprised of 1 printer that's $500 and a computer that's $500. I'd like to…
-
Send email to people who fill out form at a later time
In trying to use Smart Sheet as a way to track applicants, and even use a form as an application, I'd like to be able to notify applicants that did NOT get the job that they didn't get the job. Is this even possible if I collect email addresses?
-
New JIRA tickets don't appear in linked Smartsheet file?
I'm using the JIRA+Smartsheet connector app. I created two sample JIRA tickets and was able to get these tickets to appear in a Smartsheet file. I then created 600 new JIRA tickets and these aren't syncing to the same Smartsheet file even though the same filtering criteria should be met. Can someone help me to troubleshoot?
-
Counting number of tasks, by top level then by RAG status
Hi everyone My project has 4 Level 1 Tasks and about 300 sub tasks at up to 5 levels. I've been asked to count the 300 tasks by top level task, split by RAG i.e. Top Level Task 1 (100) - Red (3) - Amber (27) - Green (70) Top Level Task 2 (150) - Red (2) - Amber (8) - Green (140) etc The card view is good for counting RAG,…
-
Are notifications still firing for the community?
Hello, over the past couple weeks I have noticed that I am no longer getting notifications from the community. Has something been updated or changed? I checked my notification settings and they are all set to send me emails when things are added. But I am no longer seeing those emails and there are no filters in my email…
-
How to Create a Purchase Order
Hi, I am trying to create a purchase order form from data stored in an Order intake form sheet. I need to be able to take certain fields from the intake form sheet one line at a time and create a standard looking Purchase Order in PDF that I can send for execution via DocuSign. Thanks! Alex
-
Smartsheet for Outlook
Is there a limit to the size / quantity of attachments (as part of the email) that can be added to an existing / new row? The email itself always gets forwarded (as new comment) to Smartsheet but attachment(s) seem to be hit or miss (definitely no zip files get added).