Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Need a How-To: IF [blank addends], blank, IF [values], sum
I'm working with this formula, which gives me [Expected Completion Date]: =[Planned Start Date]1 + [Expected Days Duration]1 Without values in Planned Start or Expected Days, I get #INVALID OPERATION in the Expected Completion. What's the simplest IF/THEN to use that will return a blank in EXPECTED COMPLETION if we haven't…
Creating a non-updating date
This problem specifically references two columns - The first being a flag column and the second being a date column. When the flag column is flagged, I would like the date column to get the date the flag column was flagged - and stay that date. Here is the formula I am using right now: =IF([Flag Is Flagged]4 = 1, TODAY())…
Template on Real estate Repairs Management
Hi, I am Trying to get a template if someone already worked on Real estate Management I am in charge of managing 1 of my Real estate clients Repairs & Maintenance We get calls in Or Via Email of issues i have to see when our crew can go over and then assign it to the right Field Crew Now i was thinking of doing 1 master…
Convert gannt chart into monthly revenue forecast
I'm new to Smartsheet and am trying to build a revenue forecast sheet that updates dynamically from an MS Project gannt chart of multiple contract timelines. I'd like to be able import the gannt chart and show the revenue over the gannt chart timeline, have the $ show on the gannt chart by month (or week), then have the…
Formulas that work across sheets
With no pivot table functionality & Reports having no aggregating functionality, and Sights having on wigdet capable of aggregating data we struggle to summarise or aggregate our data up. We could create a summary sheets that count/sum our data in other sheets IF Smartsheet allowed formulas across sheets (which it…
COUNTIF with WIldcards
I have a survey sheet where all columns start with specifc chars: D-, I-, O-. Each contains differing descriptions following the "-". I want to create a sum of all "D-", "I-", etc. disregarding the descriptive text following the "-". I am using COUNTIF([Column1]:[Column X],="D-*") with no luck. Always returns "0" unless I…
Formula to include a specific range and all new entries
Hi, I have a formula as per below and I want it to start calculating from row 6 to the bottom and include all new entries. Can you please help me? =SUMIF([1 - BT]6:[1 - BT]44, "KS", [1 - # of BT]6:[1 - # of BT]44)
Granting full Admin Permissions
I have taken on a new role in my organization and will be managing much of our content and data on our Smartsheets--which has already been in place and established with content prior to my arrival. I am finding myself very limited to what I can edit and share with already existing sheets (even though I have been made…
CountIF a cell word starts with
I wanted to countif number on below example. it should bring the count 3. Example : Cell-2 - "Fail - Item not available'" Cell-2 - "Fail - item out of stoke" Cell-3 - "Fail - routed to wrong one"
Data quality issue: List tasks assigned to 'unregistered' users
I want to resolve two issues; prevent people from exacerbating the existing issue and rectifying the legacy DQ issue 1) How do i prevent users assigning tasks to people who are not registered in Smartsheet? Is there a way of forcing them to select from the drop down list? 2) Whats the best way to audit all tasks assigned…
