-
I just deleted Columns in a Smartsheet and I have no backup
I thought I was in a Report. BUT I was in a filter and I deleted several columns from a sheet. I do not have a backup. In the recent history it will not show the data in the columns either. HELP!
-
How can I count dates in the past/future?
Hi, I'm trying to create a formula that counts certain actions in a column based on their date. Say, if there are three dates: 5/15/2020, 5/20/2020, and 5/30/2020, I want to be able to know which ones are in the future and which ones are in the past. In this case, the counter should return 2 dates in the past and 1 date in…
-
Reproducible Hyperlinks
I'm compiling a hyperlink section to include at the top of project sheets, a little more than a dozen in total. This collection creates my tabbed "Excel report". It will allow end users to navigate to the tabs/sheets they need. I can then save them in their feature (finance, schedule, risk, invoices, cash flow, etc)…
-
How can I count the amount of actions in one specific month?
Hi, I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month (May), I want the counter to return "5". I've been trying to use the formula below but all I get in return is a zero: =COUNTIFS([Target Due Date]:[Target Due Date], IFERROR(MONTH([Target Due Date]1),…
-
Counting amount of actions in one month
Hi, I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month, I want the counter to return "5". I've been trying to use the formula below but all I get in return is a zero: =COUNTIFS([Target Due Date]:[Target Due Date], IFERROR(MONTH([Target Due Date]1), 0) = 5)
-
How can I compare two date columns in an automated workflow?
Hi! I want to create an automated workflow which copies rows where two date columns are not equal to another sheet, how can I do this?
-
Smartsheet Form will not accept responses from all users
I created a Smartsheet Form and have begun receiving responses. One user indicated his response would not submit (See attachment). I verified his responses were not recorded on the Smartsheet. He indicated he was using Google Chrome to submit. I opened the Form on Chrome on my web browser and was able to submit his…
-
Automated Workflow Not Working
I set up a simple workflow. Once someone writes their initials in a column, it should move the row to another sheet. Except it is not moving the row to the other sheet. But when I look at the activity logs from both sheets, it says that a row has been moved from the source sheet and the destination sheet says a row has…
-
Creating an At Risk Formula
Hello Community, I am trying to create a formula that will create a flag if the tasks are not marked as Completed in the status column and the Due Date has been exceeded by 3 days. I've had nothing but headaches in trying to figure this out. I would be very grateful for any assistance you can provide with the IF formula…
-
Avoiding a massive nested IF formula - checkboxes?
Hi all, I have 5 check boxes and based on these being ticked or unticked i want to display something in another cell. It is essentially a decision tree that simply i want to work as follows: If Group 2 is not ticked (or nothing ticked) = Group 1 If Group 2 is ticked but 3, 4, 5 & Close are not = Group 2 If Groups 2 & 3 are…
