Has anyone received this error message before? What are the options for large data?
Hi All, I need some CountIFS help with counting dates, I have a sheet that has a column called Device that has either New or Existing. Then my second column is Date Installed. If the Device is New and the Date Installed has a date then I need to return the value for the total number of existing devices installed. Any help…
WHAT I'M TRYING TO DO: I would like to accomplish two things in one IF statement. Something like: =IF([This Column]@row = 1, [That Column]=true ALSO Today(), ....) WHY I'M TRYING TO DO THIS: I am trying to automate the Actual Finish column in my project management sheets such that, when % Complete reaches 100, then check a…
Hello My organization has finalized our 2020 Capital Ex Budget. Starting in January 2020, I want to create a Capital Exp Form that provides the options that were approved for the 2020 Cap Ex Budget. For example, the form would be set up as follows: 1. Is the capital expenditure request a 2020 approved capital expenditure.…
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
Hi - I have been searching through old posts and I see many mentions of a new feature that's hopefully coming soon to be able to track time in a column (24 hour format would be great). Any update as to when this may be available? Thank you!
I need to create an approval workflow where 2 criteria need to be met but it seems the only option is "or" and not "and" (see screen shot). Is there a way to have an approval sent out only if both criteria are met?
I have a new requirement to have more than attachment field in a web form. Example: the form asks for specific budget information in one section requiring upload(s), and then in another section we would like to add an area to add receipt information. It would be OK if they are stored together in the Smartsheet when…
We have a gremlin! There have been two instances now where we manually move a row, smartsheet appears to be moving it, then it ends up back on the original smartsheet. The activity tracker shows the attempts on both smartsheets. Any idea why?
We are currently having issues with lines being overwritten when more than one team member is entering information into a sheet at the same time. Anyone else experiencing these issues?