-
Formula for a carriage return within a cell
Hello i have this formula for milestones, however I would like to format it so that the "Milestone Count, Milestone Reached, Milestones to Go are all lined up to the left of the cell. I cannot change the size of the cell as there are multiple tasks in that same column. ="Milestone Count. . . . . . . " + COUNT([Notify…
-
Send Update Request via API to Contact List User
Has anybody deveoped a solution using the API's to send Update Request from a sheet? Meeting with my developer to see if we can send an update request when the PAYMENT field changes to PAID status and the DATE PAYMENT RECEIVED is blank. Then send an Update Request to the User in the Agency Contact field which will be setup…
-
Formula to calculate start date, from end date
Hi SS community, I am trying to write a formula to provide a date, 45 days prior to the start date. Ie. = [Start Date]1 - 45days Appreciate the help.
-
=SUMIF Help please:
Hi Team, Formula not working…(#UNPARSEABLE) =SUMIFS[Value of Job],2 [Sold Date:]2,>DATE(2016, 12, 31),[Sold Date:]2,<DATE(2017, 2, 1), [Result]2, 1 Trying to get “Current Month Sales” to calculate “Sold Date” when “Sold Date” matches the current month we are in (January) * * When February rolls over I wanted “Current Month…
-
Conversion Formulas / Cell Linking
I am cell-linking 2 sheets but 1 sheet records time in days and allocation: Example: 2 days and 50% Allocation = total of 8 hours spent on the project over the course of 2 days. (The duration can not be changed from days because this is our project management sheet and we use in the gantt chart to share with customers.)…
-
How to set-up net-30 days in Smartsheet
Although seems very elementary to set this up, however, I am having the toughest time trying to build this "net-30" into our invoicing report. Can someone help me out? Thanks in advance!
-
Can you reduce the depth of a row so only the 1st or 2nd rows of cell content are on view
-
Including only the most recent comment.
Hi there, Within the "Print Setup" for .pdf reports, under "Options", "Include comments" checkbox....when selecting this checkbox it prints out the full set of comments which is fantastic but can make the report quite lengthy, especially over time. However is there a way, or is it possible in future upgrades to select an…
-
Promoting Smartsheet
How much does anyone else promote this program. Have you heard the words"are these guys paying you". I just completed a mastermind group and it was a dominate topic for me in addressing how business owners can advance their company. I am wondering what is the level that all of us on here feel and promote about this…
-
Rolling Up or Consolidating Divisional Budgets
Fairly new user here. Looking for help in rolling up our divisional budgets into a consolidated budget. I have an income statement budget template for each division which has worked beautifully with callaboraters completing their info. These templates (sheets) are all exactly the same format. I'd like to have a…