-
Calculation Formulas on Reports
Our company uses Smartsheet a little differently than most but I am finding it would be very helpful if I could add formula calculations directly to the reports I pull. Currently I have to add the formulas to the sheets themselves, hide those columns and continue dragging formulas down as we add rows. Hundreds of sheets...…
-
Formula Refers to Worng Row
I have a SmartSheet that was created with nothing assigned to the primary collumn. This means many email notifications have no reference to what row or item it refers to. So, I added a formula to concatenate other collumns into the primary: =ID1 + " - P/N " + [P/N or Item #]1 + " " + Client1 + ", " + [Short Description]1…
-
Auto-filling formulas in Sheet w/ Salesforce Connector
Hi All, I have a sheet that is connected to Salesforce opportunities using the Smartsheet-Salesforce connector. I'm trying to find a way to get my formulas to auto-fill in columns that exist in Smartsheet, but not in Salesforce when a new opportunity is added to Salesforce and subsequently populates the sheet in…
-
Formulas
NETWORKDAY/S Can why does this formula above give out different numbers when the start and end date (automated by column) are the same. Eg... =NETWORKDAYS(Date created, Date modified) = no of days Date created column = 01 august 2019 (tues), Date modified column = 01 August 2019 (tues) = 1 On the next line it will say Date…
-
Combining IF formulas to Return Text Values
I have 3 columns; Start Date, End Date, Progress I can get the following formulas to work separately for row 17: =IF([Start Date]17 < TODAY(), "In Progress", "Not Started") Returns in the Progress column =IF([End Date]17 < TODAY(), "Overdue") Returns in the Progress column. I want to combine these 2 formulas in one cell to…
-
Formula that Automatically changes Date when cell changes
Is there a formula that would automatically change its date to reflect the date a cell or column changes? For example, I am creating a sheet where I want a formula that changes its date to reflect anytime someone changes the task, so the person changing the task's status doesn't have to change the date they updated the…
-
Report and Dashboard View of Planned vs Actual progress Task
I have searched the community for some solutions for what I am trying to achieve…and there were lots of information that seemed close to what I am trying to do. Many links that were shared for other blogs, articles, etc., are no longer active. So I am hoping someone from the community can help me put it together. We would…
-
formula for dates
i have a question for a data sheet with completion dates i want to create a formula to count the lines marked completed with a date.. im using count if but is not working i was able to count the entries when no date available bu using ,"") at the end of the count if after my selection if any one can help me out with the…
-
Date calculation
How do I create a cell formula that calculates a future date from another cell that has a date?
-
Changing a Date (mm/dd/yyyy) to Month Year (January 2019)
I copied this from another post and simply substituted my date range (from another sheet) and It is returning "UNPARSEABLE". Any suggestions? =IFERROR(IF(MONTH(@{Quality Database Range 1}@row) = 1, "January ", IF(MONTH(@{Quality Database Range 1}@row) = 2, "February ", IF(MONTH(@{Quality Database Range 1}@row) = 3, "March…