-
Attempting a formula with multiple criteria
Hi, can anyone help with the formula for the following required outcomes? * $0 if the management agreement has not started [Mgnt Start Date], * Equal to the chargeable amount [chargeable amt] if the Management agreement has started ie [Mgnt Start Date] in the prior month * Equal to the previous month [Jan 17] if the…
-
Cashflow formula - IF formula issue under date formatted column
Hi, I'm trying to create a project cash flow projection sheet and I'm stuck with the (see attached photo) IF formula. I need the column to be formatted as date to find the IF formula but I cant format the cells below as number/text and I believe this is the reason that the IF formula isn't working. Any help to get this…
-
Dashboards and New Item Formatting
I have created several dashboards that contain multiple reports. In each report, I have selected "Highlight Changes" to highlight any changes made in the last 30 days. The reports operate correctly, but when I open the Dashboard, the reports on the the Dashboard do not maintain the highlighting. If I click on the report,…
-
Forumla HELP! Check boxes then counting £ values in columns
Hello community This is my first post, struggling to achieve a formula command. can you help? I have several columns, one being a check box column named "Payment" When one or more of the rows is checked within this "Payment" column, I then need the system to calculate the £value across three other columns, names "30 days"…
-
Invalid recipients in Alerts and Actions rule
We have lots of alerts/actions/notification rules setup across lots of sheets. When I delete a user due to employee termination, then I get this message: "Invalid recipients in Alerts and Actions rule" I don't want to have to dig through dozens of sheets to remove the people, how can I do this on a mass scale?
-
How can I generate a project planned vs. actual S curve in smartsheet?
I have a project plan with task name and timelines. I am using the gannt chart template. i want to see an S curve: Planned vs. Actual. Wondering if there is an automated way to generate that?
-
Reports Malfunction
Hi, Are reports malfunctioning with anyone else today? I thought I was doing something wrong until I read the past community posts suggesting prior issues with reports. /-RI
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
Using reports to create Totals
Hi I am pretty new to Smart Sheet and have mainly used it for Project Plans so far. I am now looking at using it for forecasting for delivery consultants. I have created a sheet and form for them to enter forecasting for delivery for a particular customer in a given month. I would however like to be able to create a…
-
Cannot add field to attach files
Hello everyone. I am working on a sheet that will store files sent by third parties. But currently It does not give me the option to place a field to ask for attachments on the form I am working on. I started to use Smartsheet recently, so it can be quite easily to solve this problem, so please be patient. Ty all