Hello,
Is there an easy way to send an automated reminder based on an approval request? We automate approvals from some of our Smartsheets and would love for a reminder to be sent x days later if the approval status is still "Submitted".
I can't find where I can build a reminder based on the status
I have the following columns and need to return the value of something from a date through the end of the year.
1. Est Mo Contract Count - A number
2. Ave admin - Dollar Amount
3. Estimated Value - 1 x 2
4. Start Date - Start Date that 1 actually goes into effect
5. Weighted Value - Sum of 4
0
Hey guys,
I have read several posts with several workarounds for calculating a value between a Start Time and an End Time where the input and result need to be in HH:MM. I have an idea and a beginning:
1. I created two System Columns. [Start Time] as 'Created (Date)' and [End Time] as 'Modified
0
I have a VLOOKUP challenge :)
1st sheet is a project portfolio and capturing project names and a project status in a traffic light system. On another sheet I want to calculate all the "green", "yellow" and "red" amounts in out portfolio. No issues there, but if I want to create a formula to get
0
If anyone can help... I created a form on issue tracking. Went to test the form and it appeared to work fine. However nothing updated in the smart sheet. Why is that? Is there something else I should be doing? Where did the update go? Why is it not posted to the sheet?
0
Hi,
Are you able to help?
I have a column named "snag" which is a red flag check box, then another column named "PM" with drop down name initials
I need a formula that calculates, when a Red flag is raised and PM name is "XYZ" the result is = ZZ number of projects
I'm going wrong somewhere and
0
Hello,
I am getting a "Circular dependency" error when assigning a dependency, but I cannot find any circular dependencies, in fact I've just started adding the dependencies. Below is the part of the sheet where I'm having difficulty. When I try to add "199" in the depency column of any of the rows
0
Hi,
This is to seeking help how to sum the "Down Payment" & "P.G. Billing 1" when Due Date are JAN.2019, Pls refer to the attached picture.
I'm using the below formula for single column computation,
=SUMIF([Due Date 1]16:[Due Date 1]24, "JAN.2019", [Down Payment]16:[Down Payment]24)
But have no idea
0
Hello I am looking for advice on the best tool to extract data from Smartsheet to a third party graphing service and then embed the 3rd party graph in a smart sheets dashboard.
The two options I can think of are the
!. Live Data Connector to Excel or Tableau
2. Power BI desktop
Is anyone familiar
0
I know I'm getting old, but at this rate I'll never see the end of this project! :)
Pay close attention to the duration column here. These numbers don't add up!
Also, I've already submitted a help ticket. I'll post back here with the response.
Thus far, this is the only row I see like this. For what