I am using this formula to output a fee based on gross loss for insurance claim. The resulting total column shows proper dollar format when it is over $100,000 based on first IF statement. When it is either of the following IF statements, ie for losses > 500, or losses > than 0, then the "TOTAL" cell shows a dollar sign…
Has anyone out there been able to achieve this? What I would call an Active Report is as follows. A visually formatted report page that is interactive with a master sheet. The report sheet would be formatted to display a ascetically pleasing presentation of data select from the master sheet by selecting a row. This could…
I am sending update requests for a sheet that has initial items filled in by formulas - dates, as well as "Yes/No" dropdown selections. This makes it easy for the person who starts with this template to put in suggested initial dates, then ask for exact dates from these directly involved. In the sheet the editor can…
I keep track of about 40 active projects in our company. Among other things, I keep one Smartsheet on each project that shows the hours worked by several different functional areas on a week-by-week basis. I only want to put the current week's hours into the project history row for the current week after they have been…
Hi Smartsheet community! I realize there is a help area for this but I have looked ... read.. googled.. till I'm blue. So this is new and I thought in this NEW COMMUNITY maybe I could shout out for some help. I am trying to do a formula so that the smartsheet can look at a month ( column ) and then determine in another (…
One person is wanting to be notified when their RYG ball turns green, which means a document they are needing is complete. In the notifications, I can only choose for her to be notified when that column changes for anyone. Is there a formula I can do that will accomplish this? Blessings, Loann
I am trying to SUM the indented children rows in another cell that isn't the parent. Is this possible?