-
index and match formula that works in some places and not others
Hi, I have an index and match formula that works in some places and not others. I tried to attach a screen show that shows what I am trying to do along with this description. My formula in the Time and Attendance row works as expected. The data for overall status, scope, timeline, resources and funding are matched and…
-
From Web Excel Query and Smartsheet Publish Link
Hello - This is a bit of an Excel/Smartsheet question in truth. We have some workflows that depend on the From Web data function in Excel (Data -> From Web). We have switched our publish link to only be accessible to people on our account (instead of being published publicly), and the workflow now fails. I believe this is…
-
CountIFs and Date range formula
Hi, need help with a formula. I am trying to count a type from one column 'Finding Rating' against a date range in another column 'Last Completed'. So far I have tried the following but they have all come up with UNPARSEABLE. FYI Conformance is one of the types that I need to count =COUNTIFS({Finding Rating}, =Conformance,…
-
Certified Smartsheet user on the look out
Hey friends, Anyone hiring experienced Smartsheet user, if so let me know! 😁 I've been using Smartsheet for 6 years, it's so much a part of my daily work productivity and I'd like to seek out another opportunity where I could transition my skills and background in program management into. I've gain so much knowledge and…
-
IF NOT ISBLANK help
I'm trying to create a formula that will display the different colored dots in the status bar. I had success at first but one part of the formula isn't working with the others. I need it to display BLANK if Patient is blank, Gray if patient is filled in but Order Request Date is blank, Green if Complete date is filled in,…
-
How do I refer to specific child row.
Hi, I need help to do some calculations on daily basis (columns 01 to 31) at each parent level . For e.g In below screenshot If I want to calculate difference between (a child rows) "Total Vulnerability count" - "Total New Vulnerability Count" every day using generic formula so that I can apply at each parent level. what…
-
Gantt Chart with multiple dates in one line?
Hello SmartSheet community! I'd like to double check with you if Smartsheets gantt charts has the posibility of displaying multiple dates in one row, I know there's been several posts regarding this topic, but I was hoping maybe the tool has been updated? If not, is there's an easy work around to display in a Gantt chart…
-
I would like to compare week number with column name
I have a column for each work week of the year (1 to 53). I would like to append the value of HC Plan on its respective column, based on Start Week and End Week. For example, if a project starts on week 1 and end on week 2, I need to append a Head Count of 5 to the columns of Work Week 1 and 2, to keep track of HC needed…
-
Drag & Drop Emails from Outlook to Smartsheet in Chrome & Email is Deleted from Outlook
When dragging the email from my Outlook window to Smartsheet in Google Chrome it removes the file from my Outlook entirely and the email is gone. I tested this in MS Edge and confirmed it does not happen when using Edge; the file copies and uploads to Smartsheet without deleting it from Outlook. * Windows 10 Pro for…
-
Help! Multiselect Column Formula with INDEX, MATCH and HAS
Hello Smartsheet World! I am attempting to run a formula that will return contact emails depending on which departments are selected in a multi-select dropdown column. Sheet 1: Improvement Notes Smartsheet -Dept Attention column is a multi-select dropdown -Department Contacts column (in green) is a contact list that allows…
