-
Smart Sheet Freelancer Required
Seeking an independent Smart Sheet Consultant to begin work no later that the 31st October 2017 6:00 PM GMT You should be able to screen share and use our already uploaded excel spread sheets to create reports.and sights. You should be able to use the advanced functions of cell linking and formula to create forecasts.…
-
Enhancement Request: Allow Row Number retrievable from formula
I thought I had written an enhancement request for this before, but I have no record of it. I'd like to be able to retrieve the row number (not the ID, the number) using a formula. Some use cases: In this thread (https://community.smartsheet.com/discussion/finding-duplicates) Joel talks about having to sort prior to…
-
Status RYGG Automated Formula
Hello, I am trying to create a status column which updates automatically based on the following criteria: * Green (Task is Complete): “% Complete” column = 100% * Yellow (Task is In Progress): Today’s Date is less than “Planned End Date”, and “% Complete” is less than 100% * Red (Task has not Started on Schedule): Today’s…
-
Auto-populate a value based on dropdown
I am trying to have a column with dropdown choices auto-populate a value in the next column. If IP-A is chosen in the AssetType column, the TotalHours column should display 1. If IP-D is chosen the TotalHours should display 15. I was thinking conditional formatting would work but it only formats text/background. Is this…
-
Automated update request
Hi, I have a task that need to monitor status of monthly building reports to clients. The process is like as following: 1. Form department will generate building reports (each person in Form department has their own portfolio). 2. they will fill in the form on SmartSheet to input when they create the building reports and…
-
Need help with date range overlap formula
Please see attached screenshot. I use the "Duplicate" column to show whether or not there is an overlap in the date range between new entries and the "Start Date" & "End Date" columns. In Excel, the following formula works great: =SUMPRODUCT((D2<enddate)*(E2>=startdate))>1 I know that Smartsheet doesn't support SUMPRODUCT.…
-
Importing Excel Formula into SmartSheet
I imported my URL builder in Excel with formulas so that my marketing team can all use it. The formula is "#UNPARSEABLE" This is what I had in Excel: =D3&"?RecType="&E3&"&utm_medium="&F3&"&utm_source="&G3&"&utm_campaign="&H3&"&utm_content="&I3 Can someone help? I did substtitue & with + but it isn't delivering my long-tail…
-
SUMIFS Formula
We currently have a SUMIF formula that sums up a Annualized Estimate for a specific Ministry. The Sheet with this data uses a form to populate additional rows. The currently working formula is =SUMIF(Ministry:Ministry, [Ministry Name - Annualized Estimate], [Annualized Estimate]:[Annualized Estimate]) We wanted to break…