-
IF(AND formula
Hi, I am using this formula =IF([Warranty Status]@row = "Warranty Expired", IF(AND([Asset Status]@row = "In-Stock), "Out Of Warranty","")) Its says the formula is unparseable. I can't figure out the issue with the formula. Help is appreciated.
-
Undo Function After Saving
Smartsheet should still allow us to undo after a sheet/report autosaves. This has really frustrated me. As I'm trying out certain things on my sheets, smartsheet will autosave and it totally screws me over. Also, I'm shocked y'all don't have a restore function - where we can restore sheets to an older version if someone…
-
Need advice on sheet layout
I'm looking for some advice or suggestions on sheet layout. Attached is an apartment "booking" sheet, all currently manually entered from another source form. As you can see it's not well laid out, it doesn't easily show periods when a given room might (or might not) be available. In general, just very janky. But, I can't…
-
Burndown Chart
Hi Everyone, I have a question about how to drive a burndown report in a Project summary: I've built a burndown sheet that contains the Application Name, Baseline Finish, and Actual Finish dates. (Those three columns are linked to other project schedule sheets.) I've also built a Cutover Date column that lists every…
-
Need both Text and Contact List versions of people on same sheet
I have a PowerBI report that pulls data from a Sheet. When I use a contact list on the sheet, the email address shows on the report, not the name. The customer wants to see names, not email addresses. I need the contact list column because I have reports that filter on logged in user. I don't want people to have to enter…
-
Cant Delete Sheet that I created
I try deleting the sheet i created in a workspace it shows that it work but then when I refresh the page or log out then it comes back. I tried moving them in to a folder in the workspace and they are not movable. I tried deleting them in 1 by 1 then I noticed some of them has this locked access and It is telling me to…
-
“File Creation Restriction”
Hello There , before smartsheet switched to the new license type, the users to whom I gave editing permissions could not share the page unless I granted them permission. In addition, users did not have the ability to create pages. This way, as the admin, I was aware of all the pages created in the company and could…
-
Stopwatch Style Time Tracker
I believe the community has been looking for a solution for years. I have successfully created a way to have Stopwatch Style Time Tracking – On any sheet, at the parent or child row, by individual, and allowing manual edits! This is without using Resource Management. I used Bridge to handle the automation and two sheets…
-
Resource Allocation and Output Tracking in RM
Good day, We recently encountered a situation on our manufacturing floor where a bottleneck in one area was impacting downstream processes. To address this, we explored options for reallocating cross-trained employees across the facility. Each workstation produces a fixed volume of product based on the number of operators…
-
User Creation Error
Hi There ; While creating an user i am getting attached error.This person i would like to create as a viewer.How can i solve this issue ?