-
Need a column formula to pull balance from last row
I have looked at multiple questions and threads on the community and not found an answer that works. I am trying to create a column formula that pulls the [Balance] from the previous row into the current row entry. I was getting a #circular reference error, I tried IFERROR and some recommendations on other posts, but…
-
move workflow stopped because of system column
Hello I have 2 sheets a master sheet and a sheet that is populated from a form. the first few columns on the master sheet are filled in via form, that data is then used for estimation which is filled into the second form. the data from the first form is added to the data from the second form on the second sheet using…
-
Can user WITHOUT a license who has Sheet permissions set to 'Editor-Can Share', share a Sheet
I have a consultant, who does not have a license, who I gave Sheet permissions 'Editor-Can Share'. They attempted to share the Sheet and received an error message saying that they do not have "sufficient permission to modify sharing on this item". As far as I can see they have permissions, so I don't know why they are…
-
Text Wrapping is not working.
Hi, I've created a new sheet and a form, I've applied text wrap to the columns that might need it and I've tested certain cells, inputting more text than the cell than would be visible. I've clicked an unclicked the text wrap button on the menu... nothing is happening. I've saved and refreshed the sheet...still no text…
-
Best practices for project sheets so data can roll up to portfolio dashboard?
My team manages many projects, each having a sheet with many parent and child tasks. I am researching ways to roll project data up into overall portfolio views for leadership but all of the PPM/PPO templates Smartsheet provides seem to pull portfolio data from an "intake sheet" which is not a process we employ. I'm finding…
-
Connect WordPress form to Smartsheet for Record Keeping
Is there a way I can populate a Smartsheet with entries from a WordPress form? We use the Gravity Forms Addon
-
The sheet that you are attempting to access is no longer published
Hi all, We are getting this error message on smartsheets today, sheets that are used regularly throwing up these messages. Once you click accept and continue it's ok but any ideas as to what is causing this?
-
Digital Signature
Hi all, I've searched for this topic, but i could not find directly what i was looking for. Is there on Smartsheet any functionality for digital signature that doesn't require pairing our service with another software? All the solutions i saw were about using another software to do it, but those were from 2017. I am just…
-
CountIFs formula question
Hi, I am trying to count the amount of time a drop down is selected within a range of columns that is in a specific location (separate column with it's own values). My goal is to count how many times Location (A-C) have the value Properly demonstrated and Not Properly Demonstrated selected. This is currently the formula I…
